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

Power BI Ideas Admin on 06 Jul 2020 00:05:44

RE: Conditional Formatting for Total and Subtotals in Matrices

Very Important Must Have feature in Power BI, please add ASAP, Would be very useful for many developers

's profile image Profile Picture

Subramaniam Iyer on 06 Jul 2020 00:05:39

RE: Conditional Formatting for Total and Subtotals in Matrices

This is deal breaker in our org to switch to BI please implement

's profile image Profile Picture

Juan Pablo Martínez on 06 Jul 2020 00:05:35

RE: Conditional Formatting for Total and Subtotals in Matrices

Please include! This is very useful.

's profile image Profile Picture

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

RE: Conditional Formatting for Total and Subtotals in Matrices

This is an important feature to consider. Thank you!

's profile image Profile Picture

Toby Lupton on 06 Jul 2020 00:05:24

RE: Conditional Formatting for Total and Subtotals in Matrices

Seems to be a common theme here for the want to apply simple formatting to data tables so that the visuals are consistent throughout. For me and my company, a small thing like this is likely to be a deal breaker when deciding to opt to switching from Excel/PowerPoint to Power BI as a reporting tool.

's profile image Profile Picture

Atul Borkar on 06 Jul 2020 00:05:23

RE: Conditional Formatting for Total and Subtotals in Matrices

I agree it is very important in most cases that we report out.

's profile image Profile Picture

Liu Jiawei on 06 Jul 2020 00:05:21

RE: Conditional Formatting for Total and Subtotals in Matrices

Such a seemingly simple function yet not available after 3 years? Can PowerBI still catchup in terms of BI capabilities?

's profile image Profile Picture

Vinod on 06 Jul 2020 00:05:19

RE: Conditional Formatting for Total and Subtotals in Matrices

is there any update on this? are we any close to close this idea?

's profile image Profile Picture

Anastasia on 06 Jul 2020 00:05:18

RE: Conditional Formatting for Total and Subtotals in Matrices

must have

's profile image Profile Picture

Aleh Kalinichau on 06 Jul 2020 00:05:17

RE: Conditional Formatting for Total and Subtotals in Matrices

5,109 votes and this isn’t (yet!) on our near term roadmap.
Magic! No comments.