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

    Eugenia Burleai on 06 Jul 2020 00:11:10

    RE: Conditional Formatting for Total and Subtotals in Matrices

    will be grate to have this option

    's profile image Profile Picture

    Alan Stanford on 06 Jul 2020 00:11:07

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is a big need for any financial department. It is important to show red negatives in matrices in order to make the important numbers stand out. The conditional formatting to display negative numbers in red is useless if I cannot do the same for the subtotals and grand total numbers.

    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:10:58

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I know this issue seems minor to MS, but matrices with conditional formating, while not sexy, are widely used. and the conditional formatting missing from subtotals is the first thing the users notice when using our reports
    Also, don't forget to add a switch to turn off Grand Totals separately from Subtotals. And please add set column widths.
    Thanks.

    's profile image Profile Picture

    Andrea on 06 Jul 2020 00:10:46

    RE: Conditional Formatting for Total and Subtotals in Matrices

    when will this feature be implemented?

    's profile image Profile Picture

    Satish on 06 Jul 2020 00:10:43

    RE: Conditional Formatting for Total and Subtotals in Matrices

    An imp feature missing. Hopefully this will be implemented soon

    's profile image Profile Picture

    claire on 06 Jul 2020 00:10:35

    RE: Conditional Formatting for Total and Subtotals in Matrices

    would love to see this implemented as quickly as possible, we have a number of power bi users at bluescope and for reporting purposes will make the visuals tell the story more quickly

    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:10:34

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Hello Power BI team,

    I'm really sad that is is still in backlog and has been for over a year. Business users are really requesting this often.

    's profile image Profile Picture

    Rafael Mafra on 06 Jul 2020 00:10:24

    RE: Conditional Formatting for Total and Subtotals in Matrices

    We need it urgently!
    A possible alternative would be to create a dax function that returns RGB Collor formatting

    's profile image Profile Picture

    john on 06 Jul 2020 00:10:11

    RE: Conditional Formatting for Total and Subtotals in Matrices

    please do make this happen

    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:10:09

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This functionality is REALLY needed