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 Ideas Admin on 05 Jul 2020 23:53:48

RE: Conditional Formatting for Total and Subtotals in Matrices

Please include this in the next update. This idea originated 3 years ago...having to explain why this isn't something we can do is very frustrating.

's profile image Profile Picture

Anonymous on 05 Jul 2020 23:53:35

RE: Conditional Formatting for Total and Subtotals in Matrices

You should be ashamed not having implemented this feature yet. Please stop working on fancy features and focus on the basic ones that are desperately missing (because this is unfortunately not the only one).

's profile image Profile Picture

Bryan Chatman on 05 Jul 2020 23:53:30

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add conditional formatting for totals. This is a must have! Customers do not understand that this is not possible.

's profile image Profile Picture

RB on 05 Jul 2020 23:53:29

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add conditional formatting for totals. This is a real important ...

's profile image Profile Picture

Ebrahim Power BI User on 05 Jul 2020 23:53:28

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add conditional formatting for totals

's profile image Profile Picture

sue on 05 Jul 2020 23:53:25

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add. When the visual is being used for a dashboard it's important to have the formatting carry to the total for an aggregated result.

's profile image Profile Picture

Rob Lam on 05 Jul 2020 23:53:25

RE: Conditional Formatting for Total and Subtotals in Matrices

Looking to have this added as well

's profile image Profile Picture

Jenn on 05 Jul 2020 23:53:24

RE: Conditional Formatting for Total and Subtotals in Matrices

Please implement this ASAP. The subtotal row headers and row values need to be visually distinguishable from each other. Otherwise they look like the exact same to the users, which can be misleading

's profile image Profile Picture

brander@gmail.com on 05 Jul 2020 23:53:24

RE: Conditional Formatting for Total and Subtotals in Matrices

Must have

's profile image Profile Picture

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

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add asap since at the moment its impossible to make tables in financial reporting look somewhat decent. The possibility to add the expand
icon only at certain levels (and have the others always expanded) would also be a big improvement.