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
Would be really from help!
RE: Conditional Formatting for Total and Subtotals in Matrices
This feature is needed. For example in the case that you have a matrix with values of different currencies, and you want to put a column for the currency, you don't have a way to take out the value in the total row for that column that is text.
RE: Conditional Formatting for Total and Subtotals in Matrices
badly needed!!
Please also add "Rename on Total" function too.
Thank you.
RE: Conditional Formatting for Total and Subtotals in Matrices
In most cases the "Total" line is the one that bring the most value. This feature should be there to allow it to stand out better.
RE: Conditional Formatting for Total and Subtotals in Matrices
Crucially needed feature!
RE: Conditional Formatting for Total and Subtotals in Matrices
This is very basic functionality from Excel and desperately needed.
Please, Power BI team, stop adding fancy bells and whistles on top of a crumbling foundation. You need to get the basics figured out first.
My organization is filled with heavy Excel users, and it's impossible to get them to take Power BI seriously when it's lacking basic functionality like this.
RE: Conditional Formatting for Total and Subtotals in Matrices
WE. NEED. THIS. In excel it was very easy to tell what was negative/decreased (RED) and what was positive/increased (BLACK), for both normal data AND the total rows/columns. How is this simple feature still not implemented two and a half years later...???!?!?!?!
RE: Conditional Formatting for Total and Subtotals in Matrices
The message is clear :)
RE: Conditional Formatting for Total and Subtotals in Matrices
The new conditional formatting is a much-needed feature, so thanks for providing it. What would be really useful however is to be able to specify if the formatting should be applied to just the lowest level of data displayed (in hierarchy terms), or only to the subtotals, or all.
RE: Conditional Formatting for Total and Subtotals in Matrices
Here is a workaround:
https://stackoverflow.com/a/57218068/1903793
It is a necessary feature for any boss who sees his employees but cannot see the total he delivers.