Skip to main content

    Power BI

    Needs Votes

    Epic idea: Custom totals for tabular visuals

    Vote (4538) 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 (481)
    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

    Miguel Myers's profile image Profile Picture

    Jesse on 06 Jul 2020 00:02:22

    RE: Epic idea: Custom totals for tabular visuals

    Come on guys, cringing when I'm presenting reports and having to explain this

    Merged Idea (2)