Skip to main content
Microsoft Idea

Power BI

Merged

Toggle Totals for Individual Fields

Vote (4) Share
AndrewK's profile image

AndrewK on 29 Jul 2017 02:32:42

In a table or matrix viz, we have the option currently to turn all totals or subtotals on or off. We should be able to toggle totals and subtotals for each column or row header field individually.

Perhaps there is a limit like the header field must have less than X values, that would be fine.

This is needed because sometimes measures make sense in a particular context but not in aggregate, and i want to see those next to measures that make sense in a context and in aggregate.

One example of this is sales by month and cumulative sales growth against last year. The first makes sense both in context and aggregate. The second does not (or is not intuitive).