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
Clients are on the need of this enhancement. Developers, please, consider it!
RE: Conditional Formatting for Total and Subtotals in Matrices
Please add to Conditional Formatting section with an Off/On option to "Apply to Total". It would be very useful to have this since we are trying to call attention to the conditional formatting.
RE: Conditional Formatting for Total and Subtotals in Matrices
Fully agree, this is extremely useful for our clients. Please implement.
RE: Conditional Formatting for Total and Subtotals in Matrices
can't wait for it!
RE: Conditional Formatting for Total and Subtotals in Matrices
'Eagerly waiting for this feature. Team, pls implement this feature at the earliest.
-Rajkumar
RE: Conditional Formatting for Total and Subtotals in Matrices
The lack of conditional formatting available on totals (or tiles instead) is a big limitation for certain clients reporting needs to the point where the result is that it is ultimately unusable
RE: Conditional Formatting for Total and Subtotals in Matrices
Waiting too...
RE: Conditional Formatting for Total and Subtotals in Matrices
We are still waiting for this feature...
RE: Conditional Formatting for Total and Subtotals in Matrices
This is from a comment by Ramy Saroufim in the November Power BI Desktop update feature summary:
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2017-feature-summary/
"Comparing Subtotals to each other within the same scope can technically be done on a Scale-per-Scope basis. However, the Customers feedback we got thought it would visually interfere with the main details scale."
Which wouldn't matter if you could turn on/off conditional formatting on totals/subtotals. Conditional formatting on totals/subtotals is just as important as on values. E.g. If comparing sales vs budget by region, you also want to clearly see if you total sales are over/under budget.
RE: Conditional Formatting for Total and Subtotals in Matrices
Agree.
Wonder why the Power BI Team omits such basic functionality and then waits for someone to put an "idea" and implement it.