Skip to main content

Power BI

New

Subtotals in matrix/table: add the dimension as a label to the subtotal

Vote (1) Share
Pieter van der Zijpp's profile image

Pieter van der Zijpp on 03 Feb 2023 10:39:04

Such a basic, essential feature for financial reports which is included in every possible report builder except Power BI. Please give us the option to add the dimension as a label to the subtotal.


For example: total EBITDA, total revenue, total gross margin etc.


Currently the only way to have the dimension and its respective subtotal line up is if you choose to position the subtotal above instead of below its components. This is undesireable for many financials and the alternative is a nearly unreadable report with lots of different indistinguishable totals in the rows.


Seems like such an easy fix and it is bizarre to me that this is still not included in the standard matrix visual. Certain 3rd parties have fixed this problem but charge rates that evaporate your margin if you're a consultant.