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
Update on this please!
RE: Conditional Formatting for Total and Subtotals in Matrices
THIS IS SO SIMPLE!.....It has been 2 years..... Microsoft figure it out! Or hire me so I can figure it out.
RE: Conditional Formatting for Total and Subtotals in Matrices
Yes please!!
RE: Conditional Formatting for Total and Subtotals in Matrices
Yes, indeed a very important feature.
RE: Conditional Formatting for Total and Subtotals in Matrices
We need this functionality, it ruins the whole concept of a dashboard when you realize you don't have an option for color coding subtotals and totals, why limit? If you don't want color coding for totals then enable on and off, other tools has it and is a decision point to go to another tool when people realize is not possible.
RE: Conditional Formatting for Total and Subtotals in Matrices
Yes please!!
RE: Conditional Formatting for Total and Subtotals in Matrices
It is crazy that you need to go to the lowest level of data to see conditional color formatting. We need to see RED for ANY negative values (including subtotals). If you can't look at aggregated data, what is the point of visualizations and summarized reporting? This is a serious gap- all other reporting tools we work with have this. Any number or field regardless of whether it is a subtotal should be able to have conditional formatting.
RE: Conditional Formatting for Total and Subtotals in Matrices
The lack of this formatting causes no end of confusion, e.g. red when below zero on the rows but the black - but still below zero - at the subtotal level. It really needs sorting.
RE: Conditional Formatting for Total and Subtotals in Matrices
Yes this is a must please! I need this for a matrix calculating deltas and it doesn't look great when the values have conditional formatting but the subtotals/totals do not...
RE: Conditional Formatting for Total and Subtotals in Matrices
PBI team, pls it's basic element for conditional formatting....