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

    Muzaffer on 05 Jul 2020 23:13:36

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I need this feature to show region and subregion totals and subtotals

    's profile image Profile Picture

    Nick on 05 Jul 2020 23:13:17

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I am desperately needs this feature for our finance department

    's profile image Profile Picture

    Javier Buendía Carrera on 05 Jul 2020 23:13:07

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I agree with this improvement. When you have a matrix when you need extra levels of information, you need to apply the correct conditional formatting for all data.

    's profile image Profile Picture

    Sasha Marsee Holder on 05 Jul 2020 23:12:54

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I agree. This makes me look bad presenting all negative numbers in red, but the results are not in red!

    's profile image Profile Picture

    AnilP on 05 Jul 2020 23:12:44

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This has to be enabled as it doesn't make any sense having it for the rows and columns but not to the totals & Subtotals

    's profile image Profile Picture

    Rebecca H on 05 Jul 2020 23:12:42

    RE: Conditional Formatting for Total and Subtotals in Matrices

    It looks so odd having the values and not the totals conditionally formatted. Please can this be added! Thanks.

    's profile image Profile Picture

    Lim Soon on 05 Jul 2020 23:12:13

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please provide this feature. Thanks!

    's profile image Profile Picture

    Walter Suarez on 05 Jul 2020 23:12:11

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Really it something basic for our presentations, as said below, sometimes the subtotal are as important (or even more) than detailed rows.

    's profile image Profile Picture

    James Symcox on 05 Jul 2020 23:10:57

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This feature would be beneficial to myself. I've voted with the other 155 people, can this be developed for the next release?

    's profile image Profile Picture

    ESMO on 05 Jul 2020 23:10:50

    RE: Conditional Formatting for Total and Subtotals in Matrices

    QlikView is able to do this basic feature for years!
    Can't believe this is not possible with PowerPI!