Power BI

Merged

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 18 Oct 2024 21:19:06

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.

Merged with Epic idea: Custom totals for tabular visuals

Comments (76)

Power BI Ideas Admin on 05 Jul 2020 23:41:21

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add asap, this is affecting the visuals

Mike on 05 Jul 2020 23:41:14

RE: Conditional Formatting for Total and Subtotals in Matrices

please add

Richard Gilbert on 05 Jul 2020 23:39:17

RE: Conditional Formatting for Total and Subtotals in Matrices

Absolutely necessary

Askar Panikkaveettil on 05 Jul 2020 23:37:55

RE: Conditional Formatting for Total and Subtotals in Matrices

Yes, indeed a very important feature.

Power BI User on 05 Jul 2020 23:37:24

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.

Steve Bedford on 05 Jul 2020 23:37:05

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.