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

Power BI User on 06 Jul 2020 00:08:25

RE: Conditional Formatting for Total and Subtotals in Matrices

Honestly some of this stuff is basic common sense , why wait for Votes for such add such a basic feature ?

's profile image Profile Picture

RP on 06 Jul 2020 00:08:03

RE: Conditional Formatting for Total and Subtotals in Matrices

Looking forward to the July 2020 release. We need this when adding month-over-month variance analysis columns (e.g, ∆$, ∆qty, ∆%). Thanks.

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/conditional-formatting-totals-subtotals

's profile image Profile Picture

Salvatore Cagliari on 06 Jul 2020 00:08:02

RE: Conditional Formatting for Total and Subtotals in Matrices

It's a pain to open all levels of a hierarchy to see the conditionally formatted cells on the lowest level.
This extension of conditional formatting would be very helpful.

's profile image Profile Picture

Mario on 06 Jul 2020 00:07:57

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add this feature asap. Thanks

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:07:57

RE: Conditional Formatting for Total and Subtotals in Matrices

This feature is highly needed in our organization

's profile image Profile Picture

Rob Girardin on 06 Jul 2020 00:07:53

RE: Conditional Formatting for Total and Subtotals in Matrices

C'mon Microsoft. These is very basic and a must. Having the rows formatted but not the totals just looks bad

's profile image Profile Picture

Giles Dutton on 06 Jul 2020 00:07:53

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add this feature asap. Thanks.

's profile image Profile Picture

Danny Dennison on 06 Jul 2020 00:07:24

RE: Conditional Formatting for Total and Subtotals in Matrices

July 2020!
https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/conditional-formatting-totals-subtotals

's profile image Profile Picture

Subash Gautam on 06 Jul 2020 00:07:20

RE: Conditional Formatting for Total and Subtotals in Matrices

Basic functionality, would be nice to have it sooner than later.

's profile image Profile Picture

Dipali Belamkar on 06 Jul 2020 00:07:02

RE: Conditional Formatting for Total and Subtotals in Matrices

This is very basic feature we should have in Power BI. When customer wants to see performance of the product & subcategory of that product, It is very likely that customer would like to see performance at product level & then at subcategory level.