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

    Yoeri on 05 Jul 2020 23:30:47

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Any idea on when this will be implemented?

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:30:38

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Cannot believe this idea is almost TWO YEARS old and still has not been implemented in the many upgrades

    's profile image Profile Picture

    John on 05 Jul 2020 23:30:26

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please add.

    's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:30:13

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is a huge miss. In many cases, our team cannot leverage conditional formatting because this seemingly simple piece is missing.

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:30:12

    RE: Conditional Formatting for Total and Subtotals in Matrices

    ITS REALLY REALLY NEED!!!

    's profile image Profile Picture

    Dayvi123 on 05 Jul 2020 23:30:06

    RE: Conditional Formatting for Total and Subtotals in Matrices

    It's September 19, 2018. How is this not a feature yet?

    's profile image Profile Picture

    Scott Stamper on 05 Jul 2020 23:30:06

    RE: Conditional Formatting for Total and Subtotals in Matrices

    It is really odd to me that this issue has not been addressed. I am guessing the problem has to do with context, but perhaps someone from Microsoft could share why this is still missing?

    's profile image Profile Picture

    Laura on 05 Jul 2020 23:30:00

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I need it now! It looks terrible just without conditional formatting!

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:30:00

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I agreed and really need subtotal and total formatting.
    Please, improve it.

    's profile image Profile Picture

    Mark Heydon on 05 Jul 2020 23:29:47

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Seems ridiculous that conditional formatting is applied to the values in a column of a table but not the sub-totals and totals for the very same column.