Power BI

Completed

Conditional Formatting for Total and Subtotals in Matrices

Vote (5185)

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)

Comments (547)

b7d54f5a 7f42-4902-97b1-f05511b368c4 on 05 Jul 2020 23:04:15

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.