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)
RE: Conditional Formatting for Total and Subtotals in Matrices
Is there any update on when conditional formatting will be applied to subtotals, etc?
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....
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.
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...
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.
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
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.
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
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
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