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

O M on 05 Jul 2020 23:29:44

RE: Conditional Formatting for Total and Subtotals in Matrices

I really need total and sub-total formatting!

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:29:32

RE: Conditional Formatting for Total and Subtotals in Matrices

Really need this! I'm replacing our excel corporate financial reports with Power BI and this is a big requirement!

's profile image Profile Picture

Shelley on 05 Jul 2020 23:29:30

RE: Conditional Formatting for Total and Subtotals in Matrices

This is important. I can color code performance by month, but then the subtotals are not. This is going to make me look goofy to execs. They won't understand why I applied the conditional formatting by month and then left YTD white. I even want to use the same rule on the YTD as the monthly data.

's profile image Profile Picture

Bonaventura Konrad on 05 Jul 2020 23:29:28

RE: Conditional Formatting for Total and Subtotals in Matrices

Do it now please!

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:29:02

RE: Conditional Formatting for Total and Subtotals in Matrices

Need this big time! Tired of telling my executives 'sorry, Power BI doesn't support that'.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:29:01

RE: Conditional Formatting for Total and Subtotals in Matrices

Absolutely. It's strange that the totals row cannot be formatted. In my case, I want to center it but cannot.

's profile image Profile Picture

Mathew Power BI User on 05 Jul 2020 23:28:52

RE: Conditional Formatting for Total and Subtotals in Matrices

Agreed, it's so weird to see the detail formated and not the totals

's profile image Profile Picture

Roben on 05 Jul 2020 23:28:38

RE: Conditional Formatting for Total and Subtotals in Matrices

if the values can be formatted, one should be able to format the totals.

's profile image Profile Picture

Adrian C on 05 Jul 2020 23:28:01

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add this

's profile image Profile Picture

Alberto Guajardo on 05 Jul 2020 23:27:30

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add