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

Kent Bell on 06 Jul 2020 00:02:23

RE: Conditional Formatting for Total and Subtotals in Matrices

This needs to be fixed, why would you not apply the same conditional formatting to totals and subtotals

's profile image Profile Picture

Jesse on 06 Jul 2020 00:02:22

RE: Conditional Formatting for Total and Subtotals in Matrices

Come on guys, cringing when I'm presenting reports and having to explain this

's profile image Profile Picture

Zeenat Goyal on 06 Jul 2020 00:02:21

RE: Conditional Formatting for Total and Subtotals in Matrices

The customer is looking to have the conditional formatting the same as in the column for subtotals and totals as well and they are not ready to digest it that it is not provided in the tool so far.

's profile image Profile Picture

Wildmight on 06 Jul 2020 00:02:18

RE: Conditional Formatting for Total and Subtotals in Matrices

This is a huge issue right now, I'm not able to explain to business users why the conditional formatting is not working for row totals in matrix. Is there any way to expedit this? It can't be a huge change.

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:18

RE: Conditional Formatting for Total and Subtotals in Matrices

Why was this not default from the beginning? A simple slider to turn off and you cover everyone's needs. What a huge miss! This prevents use from transitioning Executive level reporting to PBI :(:(

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:17

RE: Conditional Formatting for Total and Subtotals in Matrices

This is a must have - can't believe its not on a priority list

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:15

RE: Conditional Formatting for Total and Subtotals in Matrices

This is a huge disappointment for our users who we just moved over from a competing BI product.

's profile image Profile Picture

Beatriz Guidil on 06 Jul 2020 00:02:14

RE: Conditional Formatting for Total and Subtotals in Matrices

Let's implement this. Please

's profile image Profile Picture

Martin Turcotte on 06 Jul 2020 00:01:58

RE: Conditional Formatting for Total and Subtotals in Matrices

Wow! 4511 votes and still no movement on this feature... Speaks volume to the value attached to feedback provided by users.

's profile image Profile Picture

Bill on 06 Jul 2020 00:01:58

RE: Conditional Formatting for Total and Subtotals in Matrices

This is a must have feature, especially since people looking at reports tend to focus in on the total columns to start. I can do this in Excel, ClikView, and a variety of other products, PBI needs the same.