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

    ed70ae6b 102b-435d-913d-a1c6433f624d on 06 Jul 2020 00:09:38

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This challenges formatting for $values in financial reports....

    's profile image Profile Picture

    8c38a614 8309-45ae-a6c5-362517aa2e77 on 06 Jul 2020 00:09:37

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I would like to see this, so we can compare the grand totals to the RAG rating (for example) of the rows above.

    's profile image Profile Picture

    519a00e1 432f-4010-931e-d08db4f0a484 on 06 Jul 2020 00:09:32

    RE: Conditional Formatting for Total and Subtotals in Matrices

    please add this feature this is a must have.

    's profile image Profile Picture

    1a5762a7 899a-40c5-b957-cba37502f9ce on 06 Jul 2020 00:09:30

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is a must feature. Financial reports misleading with partial conditional formating.

    's profile image Profile Picture

    4824b9f9 c4aa-4498-b8d9-c31bfbe2591b on 06 Jul 2020 00:09:27

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Agree, this should be there, please add.

    's profile image Profile Picture

    dc5eead5 0665-4673-a00d-27226ca0a314 on 06 Jul 2020 00:09:19

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Agreed, definitely a must have. Please add this.

    's profile image Profile Picture

    3fb247ff a4dc-43de-a356-67f68d0c71e8 on 06 Jul 2020 00:09:17

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I'm really amazed that this still isn't added... I would say this is a quick win.

    's profile image Profile Picture

    40c3341b 1207-482e-9073-39fc50bc9da5 on 06 Jul 2020 00:08:59

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I would have thought, this should have been released when conditional formatting for matrices was released; without people asking for this.
    It's weird that conditional formatting went through UAT and made it to GA without this feature.

    's profile image Profile Picture

    6d767531 e9d7-4a9d-b248-b242d089d49a on 06 Jul 2020 00:08:57

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please add this !

    's profile image Profile Picture

    8fd38116 7903-4800-b92b-267d6d300c1b on 06 Jul 2020 00:08:45

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is a very basic feature - please add!