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 (547)
RE: Conditional Formatting for Total and Subtotals in Matrices
This is needed while creating financial reports .
RE: Conditional Formatting for Total and Subtotals in Matrices
it is a big need for the financial report and general for reporting
RE: Conditional Formatting for Total and Subtotals in Matrices
will be grate to have this option
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.
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.
RE: Conditional Formatting for Total and Subtotals in Matrices
when will this feature be implemented?
RE: Conditional Formatting for Total and Subtotals in Matrices
An imp feature missing. Hopefully this will be implemented soon
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
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.
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