Power BI

Merged

Conditional Formatting for Total and Subtotals in Matrices

Vote (5185)

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 18 Oct 2024 21:19:06

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.

Merged with Epic idea: Custom totals for tabular visuals

Comments (76)

jorge lopez on 05 Jul 2020 23:57:51

RE: Conditional Formatting for Total and Subtotals in Matrices

Please implement this, thanks

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

RE: Conditional Formatting for Total and Subtotals in Matrices

Please do it soon!

Power BI Ideas Admin on 05 Jul 2020 23:56:26

RE: Conditional Formatting for Total and Subtotals in Matrices

Much needed. I'm surprised it has not been completed already. Power BI needs to concentrate on the current features while advancing. Not just work on new features.

Jack Wu on 05 Jul 2020 23:56:10

RE: Conditional Formatting for Total and Subtotals in Matrices

useful function.

Przemyslaw Remin on 05 Jul 2020 23:54:26

RE: Conditional Formatting for Total and Subtotals in Matrices

Here is a workaround:
https://stackoverflow.com/a/57218068/1903793

It is a necessary feature for any boss who sees his employees but cannot see the total he delivers.

José Pintor on 05 Jul 2020 23:54:02

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add conditional formatting for subtotals and grand totals, many thanks!

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.

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

Power BI User on 05 Jul 2020 23:52:50

RE: Conditional Formatting for Total and Subtotals in Matrices

This is another one of these, far too common, missing features in PowerBI that makes us look silly in front of people who are used to working with or seeing Excel reports. The looks you get when you tell people "it can't do that"! Please fix :-)

Mohit Khurana on 05 Jul 2020 23:52:11

RE: Conditional Formatting for Total and Subtotals in Matrices

This is a an important requirement and otherwise appears as a partial utility only. Please enable this asap with a setting "extend to Sub total / Grandtotal" :)