Skip to main content
Microsoft Idea

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

    Joy Eakins on 06 Jul 2020 00:07:01

    RE: Conditional Formatting for Total and Subtotals in Matrices

    4 years and it's still not on the roadmap???

    's profile image Profile Picture

    Steven Kienle on 06 Jul 2020 00:06:55

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Also, conditional formatting of the row headers would be a huge improvement!!!

    's profile image Profile Picture

    Donald Scott on 06 Jul 2020 00:06:55

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please, please add this in. Also, conditional formatting for matrix row header values would be super useful. So, for example, the word 'Total' in the row header can be given another colour and then the conditional formatting can work on the total row to give the same colour. Don't let me down Microsoft :)

    's profile image Profile Picture

    Jour on 06 Jul 2020 00:06:54

    RE: Conditional Formatting for Total and Subtotals in Matrices

    '+1

    's profile image Profile Picture

    Nicolas on 06 Jul 2020 00:06:41

    RE: Conditional Formatting for Total and Subtotals in Matrices

    '+1

    's profile image Profile Picture

    Power BI Ideas Admin on 06 Jul 2020 00:06:38

    RE: Conditional Formatting for Total and Subtotals in Matrices

    '+1

    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:06:31

    RE: Conditional Formatting for Total and Subtotals in Matrices

    NEEDS TO HAPPEN

    's profile image Profile Picture

    Power BI Ideas Admin on 06 Jul 2020 00:06:30

    RE: Conditional Formatting for Total and Subtotals in Matrices

    NEEDS TO HAPPEN +1

    's profile image Profile Picture

    Power BI Ideas Admin on 06 Jul 2020 00:06:30

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please Make it happen can't wait so such a simple need!

    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:06:22

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Guys, I hope this is resolved at the earliest. We cannot go back to our clients and tell them that this update has been waiting to come up since 4 years. I hope this update is pushed at the earliest. Thanks and Cheers!