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

Anne Snoeks on 05 Jul 2020 23:40:47

RE: Conditional Formatting for Total and Subtotals in Matrices

big need, but in general would be nice if you don't need to choose if the conditional formating should work on "summarization" but just on the field value.

's profile image Profile Picture

Lauren on 05 Jul 2020 23:40:31

RE: Conditional Formatting for Total and Subtotals in Matrices

This is greatly needed. It would be nice it there was a toggle button to chose whether or not you want it applied to subtotals or not.

's profile image Profile Picture

Aaron Lynch on 05 Jul 2020 23:40:21

RE: Conditional Formatting for Total and Subtotals in Matrices

Would be a BIG help!

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:40:13

RE: Conditional Formatting for Total and Subtotals in Matrices

HELLO?

's profile image Profile Picture

Michael Hughes on 05 Jul 2020 23:40:02

RE: Conditional Formatting for Total and Subtotals in Matrices

Crazy this isn't available yet....

's profile image Profile Picture

Mamadou Madus DIALLO on 05 Jul 2020 23:40:01

RE: Conditional Formatting for Total and Subtotals in Matrices

Il can't wait to use it.
💻

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:58

RE: Conditional Formatting for Total and Subtotals in Matrices

Please, this is extremely neccesary... hope we have an update soon

's profile image Profile Picture

Sergio Brenes on 05 Jul 2020 23:39:47

RE: Conditional Formatting for Total and Subtotals in Matrices

What's happening with this? We need to be creating uncomfortable workarounds for getting color for totals along with other information in one page, totals and details color coding are neccesary in one view, specially for financials!!!, people don't want to be drilling up and down for looking at what's the color for the total

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:42

RE: Conditional Formatting for Total and Subtotals in Matrices

This functionality is very basic so it does not exist in Power BI

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:42

RE: Conditional Formatting for Total and Subtotals in Matrices

This functionality is very basic so it does not exist in Power BI