Power BI

Completed

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 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)

Comments (555)

Andrej Zitnay on 05 Jul 2020 23:52:11

RE: Conditional Formatting for Total and Subtotals in Matrices

Please allow Conditional Formatting for Total and Subtotals. My P&L doesn't look right if categories are not formatted... My FD have mentioned that this is confusing. Conditional formatting should work on subtotals and totals.

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" :)

Steve on 05 Jul 2020 23:52:10

RE: Conditional Formatting for Total and Subtotals in Matrices

Quite remarkable that this product only supports conditional formatting on the values and not the totals of a matrix report in 2019.
Problem is, that if you do have the colour coding on the values and not the totals, the visual presentation of the report to the end user is misleading and a mis-representation of the results.

Tewodros seifu on 05 Jul 2020 23:52:05

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add this feature. It is really important

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

RE: Conditional Formatting for Total and Subtotals in Matrices

yes please! my vote to include this

Tim Stanley on 05 Jul 2020 23:51:55

RE: Conditional Formatting for Total and Subtotals in Matrices

This should be at the top of the Power BI "To Do" list. Having this is critical on any sales report. In my organization it is currently causing pushback on reporting that we are trying to build...after we convinced management that Power BI was the direction to go. I will agree with others that it is unbelievable this has not been implemented yet.