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

S. D. on 06 Jul 2022 16:29:29

RE: Conditional Formatting for Total and Subtotals in Matrices

It would be nice if this worked for data bars as well. Thank-you.

's profile image Profile Picture

B H on 17 Jun 2021 14:40:01

RE: Conditional Formatting for Total and Subtotals in Matrices

The correct link to the new idea is:
https://ideas.powerbi.com/ideas/idea/?ideaid=44b5ea7a-78cf-eb11-ba5e-281878bdaa58

(Sorry for the wrong link - unfortunately it seems to be impossible to edit comment...)

's profile image Profile Picture

B H on 17 Jun 2021 14:32:56

RE: Conditional Formatting for Total and Subtotals in Matrices

As Microsoft seems to ignore comments about data bars here, I created a new idea fort this:
https://ideas.powerbi.com/ideas/idea/?ideaid=28b82d9d-b14e-4749-a285-9d51e9707022

Please vote there.

's profile image Profile Picture

Christian Ellehammer on 09 Jun 2021 10:16:11

RE: Conditional Formatting for Total and Subtotals in Matrices

+1 to missing functionality for data bars.

's profile image Profile Picture

Andrew Moser on 18 May 2021 18:27:16

RE: Conditional Formatting for Total and Subtotals in Matrices

This is not completed! Let's say I have three rows of values, I can't select just one or two to show in subtotals.

's profile image Profile Picture

Hubert JANISZEWSKI on 12 Apr 2021 13:47:37

RE: Conditional Formatting for Total and Subtotals in Matrices

Totals and Subtotals Data Bars Conditional Formatting is still not implemented. I don't think this idea's status should be 'COMPLETED' .

's profile image Profile Picture

Emily Long on 26 Feb 2021 15:34:51

RE: Conditional Formatting for Total and Subtotals in Matrices

Need conditional formatting extended for DATA BARS for subtotals in the matrix. Please change the status of this idea from Completed. this is not completed!!!!!!

's profile image Profile Picture

Teresa Butler on 01 Feb 2021 20:07:44

RE: Conditional Formatting for Total and Subtotals in Matrices

Data bars! When?!

's profile image Profile Picture

Pär Adeen on 06 Jul 2020 00:16:43

RE: Conditional Formatting for Total and Subtotals in Matrices

Still missing possibility to add formatting for totals using data bars. What is the plan for this???

Remember that this is a 5'186 voted feature, that still isn't implemented and nowadays can't be voted on, and it's marked as completed. I see a big risk that there's no ongoing work to also implement this feature for data bars if this idea is not re-opened. To get some more attention to re-open this idea I also created an explicit request "120061725000539"

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:14:21

RE: Conditional Formatting for Total and Subtotals in Matrices

Are there any plan to extend conditional formatting for totals to data bars?