Skip to main content
Microsoft Idea

Power BI

Completed

Conditional Formatting for Total and Subtotals in Matrices

Vote (5185) Share
's profile image

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)
's profile image Profile Picture

Damien Size on 05 Jul 2020 23:22:06

RE: Conditional Formatting for Total and Subtotals in Matrices

Required for multiple Departemental KPI table to have an Overall KPI.

's profile image Profile Picture

Blase Marchetti on 05 Jul 2020 23:22:03

RE: Conditional Formatting for Total and Subtotals in Matrices

Definitely need this option when sharing our Overall KPI metric!

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:21:55

RE: Conditional Formatting for Total and Subtotals in Matrices

Hiya are there any news on this ? Thanks

's profile image Profile Picture

Takashi Numaguchi on 05 Jul 2020 23:21:39

RE: Conditional Formatting for Total and Subtotals in Matrices

同感です。是非早期の導入をお願い致します。

's profile image Profile Picture

Antonio on 05 Jul 2020 23:21:05

RE: Conditional Formatting for Total and Subtotals in Matrices

A must!

's profile image Profile Picture

Michael Colbert on 05 Jul 2020 23:20:46

RE: Conditional Formatting for Total and Subtotals in Matrices

I was asked in an interview what I thought Power BI was lacking, this is a great example of the type of basic formatting controls we need. Great product, but sometimes leaves you scratching your head. Please implement as soon as possible.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:20:34

RE: Conditional Formatting for Total and Subtotals in Matrices

Total column is the most critical but it fades into the background when other columns include conditional formatting and total doesn't. Goes completely against the purpose of visualizations.

's profile image Profile Picture

David Cornwell on 05 Jul 2020 23:20:31

RE: Conditional Formatting for Total and Subtotals in Matrices

Yes please - Power BI does so many other amazing things, but something like this is missing? :(

's profile image Profile Picture

Jon Teale on 05 Jul 2020 23:20:31

RE: Conditional Formatting for Total and Subtotals in Matrices

Yes please! Bit of an oversight not to include originally... looking forward to seeing it soon - hopefully!

's profile image Profile Picture

Dwight on 05 Jul 2020 23:20:04

RE: Conditional Formatting for Total and Subtotals in Matrices

I agree with Anonymous. I think it's even harder to program not to have conditional formatting on the totals...