Skip to main content

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

Alejandro on 05 Jul 2020 23:10:07

RE: Conditional Formatting for Total and Subtotals in Matrices

Clients are on the need of this enhancement. Developers, please, consider it!

's profile image Profile Picture

CZ on 05 Jul 2020 23:09:06

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.

's profile image Profile Picture

Toni on 05 Jul 2020 23:09:02

RE: Conditional Formatting for Total and Subtotals in Matrices

Fully agree, this is extremely useful for our clients. Please implement.

's profile image Profile Picture

Pejman Jamili on 05 Jul 2020 23:08:57

RE: Conditional Formatting for Total and Subtotals in Matrices

can't wait for it!

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:07:16

RE: Conditional Formatting for Total and Subtotals in Matrices

'Eagerly waiting for this feature. Team, pls implement this feature at the earliest.


-Rajkumar

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:05:53

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

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:05:48

RE: Conditional Formatting for Total and Subtotals in Matrices

Waiting too...

's profile image Profile Picture

Sergey Kompaniets on 05 Jul 2020 23:04:47

RE: Conditional Formatting for Total and Subtotals in Matrices

We are still waiting for this feature...

's profile image Profile Picture

Gil Power BI User 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.

's profile image Profile Picture

VickyD on 05 Jul 2020 23:04:10

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.