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 05 Jul 2020 23:25:58

RE: Conditional Formatting for Total and Subtotals in Matrices

Definitely need this function!

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:25:58

RE: Conditional Formatting for Total and Subtotals in Matrices

Please add.

's profile image Profile Picture

Malcolm S-J on 05 Jul 2020 23:25:58

RE: Conditional Formatting for Total and Subtotals in Matrices

Conditional formatting in totals and subtotals is a must!

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:25:46

RE: Conditional Formatting for Total and Subtotals in Matrices

That would be great addition on fields conditional formatting.

's profile image Profile Picture

Sara Sylvan on 05 Jul 2020 23:25:31

RE: Conditional Formatting for Total and Subtotals in Matrices

agreed please add if possible Power BI!

's profile image Profile Picture

Joyce on 05 Jul 2020 23:24:58

RE: Conditional Formatting for Total and Subtotals in Matrices

How many votes does this need to get attention????

's profile image Profile Picture

Bernardo on 05 Jul 2020 23:24:44

RE: Conditional Formatting for Total and Subtotals in Matrices

Conditional formatting in totals and subtotals is a must!

's profile image Profile Picture

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

RE: Conditional Formatting for Total and Subtotals in Matrices

Not much use unless this can be applied to SubTotal and Total

's profile image Profile Picture

Lars van Pelt on 05 Jul 2020 23:24:20

RE: Conditional Formatting for Total and Subtotals in Matrices

Could you at the very least add a slider in the Conditional formatting menu to 'format subtotal'? That way we can at least have the entire value formatted the same if a separate format for the subtotal is a complicated job.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:24:07

RE: Conditional Formatting for Total and Subtotals in Matrices

We need it!!