Skip to main content

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