Skip to main content

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

Michael Smith on 06 Jul 2020 00:04:09

RE: Conditional Formatting for Total and Subtotals in Matrices

Is there any update on when conditional formatting will be applied to subtotals, etc?

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:04:05

RE: Conditional Formatting for Total and Subtotals in Matrices

Please implement this, the report looks awkward and we are tired to explain this to user everytime....

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:04:05

RE: Conditional Formatting for Total and Subtotals in Matrices

Last update on this was 11th Feb, almost 11 months ago, what progress please ?

Please implement using the approach used on the Card visual (click the 3 ellipses on the Data Label colour field) but as an option on the Subtotals Font Colour field.
We produce a report forecasting hours planned for people on various projects, the individual project hours show as green, but the total wold/should show as red, indicating overloaded.

's profile image Profile Picture

Jiawei on 06 Jul 2020 00:03:50

RE: Conditional Formatting for Total and Subtotals in Matrices

This idea has been posted 3 years ago and still not implemented? I would have thought it is one of the basic and easy feature to implement...

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:03:20

RE: Conditional Formatting for Total and Subtotals in Matrices

Totally inline with the rest of people, it is very important to have the conditional formatting available for totals and subtotals as well as for the regular rows.

's profile image Profile Picture

Tore Senneseth on 06 Jul 2020 00:02:52

RE: Conditional Formatting for Total and Subtotals in Matrices

Hi all,

We struggled with these limitations as well, so we made a custom visual to fix it. It's called "Financial Reporting Matrix by Profitbase" and is available for free on Marketplace. (It was featured in the November release of Power BI Desktop.)

Any questions or feedback is greatly appreciated at our github project site: https://github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix

's profile image Profile Picture

Antonio Garcia on 06 Jul 2020 00:02:48

RE: Conditional Formatting for Total and Subtotals in Matrices

It's very important to implement this idea as soon as possible. Thanks to all MS team.

's profile image Profile Picture

Kiran Rao on 06 Jul 2020 00:02:40

RE: Conditional Formatting for Total and Subtotals in Matrices

Yes. This is important. We arent able to use Conditional Formatting just because it messes up subtotal

's profile image Profile Picture

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

RE: Conditional Formatting for Total and Subtotals in Matrices

Why is this in backlog for years and not getting any movement even though it has considerable votes?
We need this feature

's profile image Profile Picture

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

RE: Conditional Formatting for Total and Subtotals in Matrices

Please apply the conditional formatting to the higher level of data even though I drill down to the lower level in Matrix