Skip to main content

    Power BI

    Completed

    Conditional Formatting for Total and Subtotals in Matrices

    Vote (5185) Share
    's profile image

    on 12 Dec 2016 08:57:40

    The recent addition of conditional formatting for values is wonderful. However, it would be great to have the ability format subtotals and totals, as the variation on those fields are often even more important to draw attention to.

    Administrator on 23 May 2020 01:39:28

    Thanks everyone for your votes on this feature! With the April 2020 release of Power BI Desktop this is now available! https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2020-feature-summary/#_Conditional_formatting Please keep commenting on this feature with other feedback, we check the Completed items as well as ones that are still active.

    Comments (547)
    's profile image Profile Picture

    f0025a8b 3ba9-4607-9eda-687cf5f1f1c1 on 05 Jul 2020 23:22:33

    RE: Conditional Formatting for Total and Subtotals in Matrices

    If I give someone the $5 dollars I have in my pocket right now can we make this happen on the next release? The previous comment should cover why it is needed.

    's profile image Profile Picture

    c7751356 d97e-46c2-9868-7017a03b93f4 on 05 Jul 2020 23:22:30

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please implement this one ... should be quite simple and so useful

    's profile image Profile Picture

    8beb7da6 31aa-4ec5-8cc1-a4fdc3f90e98 on 05 Jul 2020 23:22:06

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Required for multiple Departemental KPI table to have an Overall KPI.

    's profile image Profile Picture

    453401a2 1b40-4c02-a3c1-cba4fcc68f04 on 05 Jul 2020 23:22:03

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Definitely need this option when sharing our Overall KPI metric!

    's profile image Profile Picture

    727a9f7a 49fa-4915-bad7-8ffb42716d08 on 05 Jul 2020 23:21:55

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Hiya are there any news on this ? Thanks

    's profile image Profile Picture

    8f146863 6513-4cdc-9c66-cdde5463f5e0 on 05 Jul 2020 23:21:39

    RE: Conditional Formatting for Total and Subtotals in Matrices

    同感です。是非早期の導入をお願い致します。

    's profile image Profile Picture

    4b1873b3 2afa-4942-bbd1-ce4e7d160aec on 05 Jul 2020 23:21:05

    RE: Conditional Formatting for Total and Subtotals in Matrices

    A must!

    's profile image Profile Picture

    37a0e18f 5f77-4996-b03a-cbad859ee297 on 05 Jul 2020 23:20:46

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I was asked in an interview what I thought Power BI was lacking, this is a great example of the type of basic formatting controls we need. Great product, but sometimes leaves you scratching your head. Please implement as soon as possible.

    's profile image Profile Picture

    879c2f73 edec-4e56-bb17-e0e25fbf492a on 05 Jul 2020 23:20:34

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Total column is the most critical but it fades into the background when other columns include conditional formatting and total doesn't. Goes completely against the purpose of visualizations.

    's profile image Profile Picture

    37a0f56d 0c6c-4852-9d0d-721823e14363 on 05 Jul 2020 23:20:31

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Yes please - Power BI does so many other amazing things, but something like this is missing? :(