Skip to main content

Power BI

Needs Votes

Epic idea: Custom totals for tabular visuals

Vote (4608) Share
Miguel Myers's profile image

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 (482)
Miguel Myers's profile image Profile Picture

Michael Smith on 06 Jul 2020 00:04:09

RE: Epic idea: Custom totals for tabular visuals

Is there any update on when conditional formatting will be applied to subtotals, etc?

Miguel Myers's profile image Profile Picture

Power BI User on 06 Jul 2020 00:04:05

RE: Epic idea: Custom totals for tabular visuals

Please implement this, the report looks awkward and we are tired to explain this to user everytime....

Miguel Myers's profile image Profile Picture

Power BI User on 06 Jul 2020 00:04:05

RE: Epic idea: Custom totals for tabular visuals

Last update on this was 11th Feb, almost 11 months ago, what progress please ?

Please implement using the approach used on the Card visual (click the 3 ellipses on the Data Label colour field) but as an option on the Subtotals Font Colour field.
We produce a report forecasting hours planned for people on various projects, the individual project hours show as green, but the total wold/should show as red, indicating overloaded.

Miguel Myers's profile image Profile Picture

Jiawei on 06 Jul 2020 00:03:50

RE: Epic idea: Custom totals for tabular visuals

This idea has been posted 3 years ago and still not implemented? I would have thought it is one of the basic and easy feature to implement...

Miguel Myers's profile image Profile Picture

Power BI User on 06 Jul 2020 00:03:20

RE: Epic idea: Custom totals for tabular visuals

Totally inline with the rest of people, it is very important to have the conditional formatting available for totals and subtotals as well as for the regular rows.

Miguel Myers's profile image Profile Picture

Tore Senneseth on 06 Jul 2020 00:02:52

RE: Epic idea: Custom totals for tabular visuals

Hi all,

We struggled with these limitations as well, so we made a custom visual to fix it. It's called "Financial Reporting Matrix by Profitbase" and is available for free on Marketplace. (It was featured in the November release of Power BI Desktop.)

Any questions or feedback is greatly appreciated at our github project site: https://github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix

Miguel Myers's profile image Profile Picture

Antonio Garcia on 06 Jul 2020 00:02:48

RE: Epic idea: Custom totals for tabular visuals

It's very important to implement this idea as soon as possible. Thanks to all MS team.

Miguel Myers's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:25

RE: Epic idea: Custom totals for tabular visuals

Why is this in backlog for years and not getting any movement even though it has considerable votes?
We need this feature

Miguel Myers's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:25

RE: Epic idea: Custom totals for tabular visuals

Please apply the conditional formatting to the higher level of data even though I drill down to the lower level in Matrix

Miguel Myers's profile image Profile Picture

Kent Bell on 06 Jul 2020 00:02:23

RE: Epic idea: Custom totals for tabular visuals

This needs to be fixed, why would you not apply the same conditional formatting to totals and subtotals

Merged Idea (2)