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)
RE: Conditional Formatting for Total and Subtotals in Matrices
It is inconsistent to have conditional formatting on the data rows but not on the totals rows and is likely to cause confusion.
RE: Conditional Formatting for Total and Subtotals in Matrices
I don't understand why this is a difficult feature to add. You already have an option to apply formatting to labels on subtotals. Why not just add an option to apply conditional formatting to subtotals too? Right now i'm showing negative numbers in red but the subtotals that are also negative are showing in black. Totally misleading and takes away from the visual purpose of the report.
RE: Conditional Formatting for Total and Subtotals in Matrices
This is the most critical feature we need in Power BI. This is available in all the reporting tools.
RE: Conditional Formatting for Total and Subtotals in Matrices
absurdity!
RE: Conditional Formatting for Total and Subtotals in Matrices
Workaround:
DimTableWithAll = UNION(ADDCOLUMNS(DimTable,"New",DimTable[Original]),ADDCOLUMNS(DimLocations,"New","Total"))
Join to DimTable via PK/SK and turn on Bidirectional Crossfiltering bingo! You just can't bold your total row unfortunately. Conditional formatting has a way to go on Power BI. Also can we please rotate the column headers!
RE: Conditional Formatting for Total and Subtotals in Matrices
It is inconsistent to have conditional formatting on the data rows but not on the totals rows and is likely to cause confusion. I would like to highlight negative values including in the overall total row.
RE: Conditional Formatting for Total and Subtotals in Matrices
Why doesn't the subtotal just inherit the formatting from the values? Seems to be the simplest solution
RE: Conditional Formatting for Total and Subtotals in Matrices
We need this, quite useless without...
RE: Conditional Formatting for Total and Subtotals in Matrices
Hi All i have done with some tricks to apply conditional formatting to total values.
http://sahayasathish.blogspot.sg/2018/05/poer-bi-conditional-formatting-on.html
let me know if its usefull
RE: Conditional Formatting for Total and Subtotals in Matrices
Agree with everyone, we can't have conditional formatting that doesn't apply to subtotals, it destroys the drill down capability of the matrix. Shouldn't really have to vote on this