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

Marouane Mechnassi on 05 Jul 2020 23:59:19

RE: Conditional Formatting for Total and Subtotals in Matrices

Hi Team,

can we have the ability format subtotals and totals, as the variation on those fields are often even more important to draw attention to.

's profile image Profile Picture

Marco Tommolini on 05 Jul 2020 23:59:18

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add this feature asap

's profile image Profile Picture

Leonardo Zuniga on 05 Jul 2020 23:59:15

RE: Conditional Formatting for Total and Subtotals in Matrices

Expanded formatting options are highly needed, in order to convince end users to transition to newer BI tools!

's profile image Profile Picture

DD on 05 Jul 2020 23:59:11

RE: Conditional Formatting for Total and Subtotals in Matrices

What everyone else said, lighthearted humor. We need conditional formatting on subtotals and grand totals, thanks in advance PBI team.

's profile image Profile Picture

Beatriz Guidil on 05 Jul 2020 23:59:08

RE: Conditional Formatting for Total and Subtotals in Matrices

Much needed. Please, implement this feature!

's profile image Profile Picture

Billy Moran on 05 Jul 2020 23:59:08

RE: Conditional Formatting for Total and Subtotals in Matrices

The lack of very basic formatting features (such as this) is preventing some users from converting over from Excel and other BI tools. The functionality is much improved, but if people do not like presenting the results because they are unattractive or confusing, they will not use it.

's profile image Profile Picture

Vince Slavov on 05 Jul 2020 23:59:05

RE: Conditional Formatting for Total and Subtotals in Matrices

please add this very needed feature!

's profile image Profile Picture

Benedict Baylon on 05 Jul 2020 23:58:54

RE: Conditional Formatting for Total and Subtotals in Matrices

Please this is too basic to be overlooked by your team. Such a shame that we used this as a replacement to an older BI tool, but doesn't have very basic formatting features that exist in others.

's profile image Profile Picture

Sébastien DB on 05 Jul 2020 23:58:53

RE: Conditional Formatting for Total and Subtotals in Matrices

please make it an option

's profile image Profile Picture

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

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add this feature.
It is a basic to want the same view for total and subtotals as for individual items!