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

    Anuj on 05 Jul 2020 23:54:25

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is really needed guys!

    's profile image Profile Picture

    Andy Mundy on 05 Jul 2020 23:54:08

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Formatting subtotals & totals is commonly used in Excel so it would be great if Power BI had that option.

    's profile image Profile Picture

    José Pintor on 05 Jul 2020 23:54:02

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please add conditional formatting for subtotals and grand totals, many thanks!

    's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:53:59

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This absolutely needs to be a standard part of Power BI. Thank you!

    's profile image Profile Picture

    Ghost on 05 Jul 2020 23:53:59

    RE: Conditional Formatting for Total and Subtotals in Matrices

    So who authorized no conditional formatting on subtotal and totals? They owe us all lunch! We need this asap Microsoft! We're like fishes out of water here without it man!

    's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:53:56

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please include conditional formatting on subtotals and grand totals, the totals are generally the most important figures and these are left unformatted

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:53:56

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please add conditional formatting for subtotals and grand totals, many thanks!

    's profile image Profile Picture

    Artur Nawrocki on 05 Jul 2020 23:53:56

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Add this ASAP, drop the AI initiatives - this is must have!

    's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:53:56

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please add conditional formatting for totals

    's profile image Profile Picture

    Mike Honey on 05 Jul 2020 23:53:55

    RE: Conditional Formatting for Total and Subtotals in Matrices

    It just looks broken the way it currently works, and always raises questions. I've never seen that presentation before in any other product.

    If given the choice, I would've gladly traded the icons released in July 2019 for this functionality. I imagine it would've also been much less work.