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

Allan Lykke Christensen on 05 Jul 2020 23:57:01

RE: Conditional Formatting for Total and Subtotals in Matrices

Microsoft, how many votes for it to be added to the backlog? You really need this feature with the new Conditional Icon display when showing it on the right side. If you don't have the conditional formatting when showing the icons on the right side, the numbers will not align underneath each other.

's profile image Profile Picture

Leo on 05 Jul 2020 23:56:54

RE: Conditional Formatting for Total and Subtotals in Matrices

Such a simple function...with such a high demand for it... why is it still under "Backlog"?

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:56:33

RE: Conditional Formatting for Total and Subtotals in Matrices

This is an obvious feature missing and makes Metrices almost not usable....

's profile image Profile Picture

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.

's profile image Profile Picture

Jad Freyha on 05 Jul 2020 23:56:20

RE: Conditional Formatting for Total and Subtotals in Matrices

This is overdue Power BI team!

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:56:19

RE: Conditional Formatting for Total and Subtotals in Matrices

Difficult to believe this request is now nearly 3 years old. Please make this happen.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:56:13

RE: Conditional Formatting for Total and Subtotals in Matrices

really need this for resource reports, where the individual lines don't show as overloaded, but the summary should

's profile image Profile Picture

Gil Power BI User on 05 Jul 2020 23:56:12

RE: Conditional Formatting for Total and Subtotals in Matrices

Power BI looks like a poor BI tool to management when we put out a report without basic functionality that all other BI tools have. Missing basic features like this is making it very difficult to sell Power BI to our management.

's profile image Profile Picture

Jack Wu on 05 Jul 2020 23:56:10

RE: Conditional Formatting for Total and Subtotals in Matrices

useful function.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:56:05

RE: Conditional Formatting for Total and Subtotals in Matrices

Do it! Do it! Do it.......... etc.