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

    Kent Bell on 06 Jul 2020 00:02:23

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This needs to be fixed, why would you not apply the same conditional formatting to totals and subtotals

    's profile image Profile Picture

    Jesse on 06 Jul 2020 00:02:22

    RE: Conditional Formatting for Total and Subtotals in Matrices

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

    's profile image Profile Picture

    Zeenat Goyal on 06 Jul 2020 00:02:21

    RE: Conditional Formatting for Total and Subtotals in Matrices

    The customer is looking to have the conditional formatting the same as in the column for subtotals and totals as well and they are not ready to digest it that it is not provided in the tool so far.

    's profile image Profile Picture

    Wildmight on 06 Jul 2020 00:02:18

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is a huge issue right now, I'm not able to explain to business users why the conditional formatting is not working for row totals in matrix. Is there any way to expedit this? It can't be a huge change.

    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:02:18

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Why was this not default from the beginning? A simple slider to turn off and you cover everyone's needs. What a huge miss! This prevents use from transitioning Executive level reporting to PBI :(:(

    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:02:17

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is a must have - can't believe its not on a priority list

    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:02:15

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is a huge disappointment for our users who we just moved over from a competing BI product.

    's profile image Profile Picture

    Beatriz Guidil on 06 Jul 2020 00:02:14

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Let's implement this. Please

    's profile image Profile Picture

    Martin Turcotte on 06 Jul 2020 00:01:58

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Wow! 4511 votes and still no movement on this feature... Speaks volume to the value attached to feedback provided by users.

    's profile image Profile Picture

    Bill on 06 Jul 2020 00:01:58

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is a must have feature, especially since people looking at reports tend to focus in on the total columns to start. I can do this in Excel, ClikView, and a variety of other products, PBI needs the same.