Power BI

Needs Votes

Epic idea: Custom totals for tabular visuals

Vote (4545)

Miguel Myers on 08 Oct 2024 05:00:00

Enabling customized calculations at the query level for subtotals and grand totals would offer greater flexibility in reporting and preserve performance. Efficient organization of control settings to modify the style of these totals separately will empower report creators to achieve their desired appearance, while addressing their need for more control and customization in reporting.

Comments (481)

Power BI User on 05 Jul 2020 23:07:16

RE: Epic idea: Custom totals for tabular visuals

'Eagerly waiting for this feature. Team, pls implement this feature at the earliest.

-Rajkumar

Power BI Ideas Admin on 05 Jul 2020 23:05:53

RE: Epic idea: Custom totals for tabular visuals

The lack of conditional formatting available on totals (or tiles instead) is a big limitation for certain clients reporting needs to the point where the result is that it is ultimately unusable

Power BI User on 05 Jul 2020 23:05:48

RE: Epic idea: Custom totals for tabular visuals

Waiting too...

Sergey Kompaniets on 05 Jul 2020 23:04:47

RE: Epic idea: Custom totals for tabular visuals

We are still waiting for this feature...

Gil Power BI User on 05 Jul 2020 23:04:15

RE: Epic idea: Custom totals for tabular visuals

This is from a comment by Ramy Saroufim in the November Power BI Desktop update feature summary:
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2017-feature-summary/

"Comparing Subtotals to each other within the same scope can technically be done on a Scale-per-Scope basis. However, the Customers feedback we got thought it would visually interfere with the main details scale."

Which wouldn't matter if you could turn on/off conditional formatting on totals/subtotals. Conditional formatting on totals/subtotals is just as important as on values. E.g. If comparing sales vs budget by region, you also want to clearly see if you total sales are over/under budget.