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

Power BI User on 06 Jul 2020 00:01:16

RE: Conditional Formatting for Total and Subtotals in Matrices

In my opinion, this is an important feature. I prefer to have the conditional icons on Total and Subtotal than on low-level rows like we have now.

's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:01:07

RE: Conditional Formatting for Total and Subtotals in Matrices

Please prioritize this. Conditional formatting of totals/subtotals is a fundamental need.

's profile image Profile Picture

Gareth Woodhouse on 06 Jul 2020 00:01:06

RE: Conditional Formatting for Total and Subtotals in Matrices

Gets my Vote. Just hit a requirement for this so there is clearly a need

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:00:56

RE: Conditional Formatting for Total and Subtotals in Matrices

IS there any timeline for acting upon this idea. This is a very basic and must feature. MS can you act fast on this

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:00:55

RE: Conditional Formatting for Total and Subtotals in Matrices

This is some basic but important and I believe also easy fix. Doing that will earn you more respect and trust from users/developers. Right now I can only tell end users MS is still improving but without a timeframe.

's profile image Profile Picture

Jonathan Watters on 06 Jul 2020 00:00:50

RE: Conditional Formatting for Total and Subtotals in Matrices

Matrix never should've come out to begin with if it lacked this feature. 3 years in and its not even on the road map? That's an embarrassment.

's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:00:37

RE: Conditional Formatting for Total and Subtotals in Matrices

when will you're going to be serious about user problem business want this feature, we need this badly, please get this ASAP we can't wait till next year MBAS for announcement than another few months for roll-out.

's profile image Profile Picture

Matthew Cornish on 06 Jul 2020 00:00:34

RE: Conditional Formatting for Total and Subtotals in Matrices

This is nearly 3years old by this point. When will it see the light of day?

's profile image Profile Picture

Sonja on 06 Jul 2020 00:00:16

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add this functionality. It's a must.

's profile image Profile Picture

Chaitanya Melimi on 06 Jul 2020 00:00:16

RE: Conditional Formatting for Total and Subtotals in Matrices

I think this is a must have feature and needs to be added otherwise what is the point of showing different levels. The whole idea is to drill down from summary to detail with the ability to see the status at the summary level.