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

Rubin Boer on 05 Jul 2020 23:36:26

RE: Conditional Formatting for Total and Subtotals in Matrices

amazing this is not just available already

's profile image Profile Picture

Leonardo Ferreira da Silva on 05 Jul 2020 23:36:23

RE: Conditional Formatting for Total and Subtotals in Matrices

This functionality is very basic so it does not exist in Power BI. Since in Excel there are several possibilities for conditional formatting in Totals, Subtotals and other cells.

's profile image Profile Picture

Jake on 05 Jul 2020 23:36:17

RE: Conditional Formatting for Total and Subtotals in Matrices

Please make this happen team!

's profile image Profile Picture

Nir Robinson on 05 Jul 2020 23:36:14

RE: Conditional Formatting for Total and Subtotals in Matrices

It's must have feature.

's profile image Profile Picture

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

RE: Conditional Formatting for Total and Subtotals in Matrices

So many situations where there are no rows or columns but only totals. Please add this feature!

's profile image Profile Picture

Benjamin van Assum on 05 Jul 2020 23:35:43

RE: Conditional Formatting for Total and Subtotals in Matrices

Must have feature please add asap!

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:35:39

RE: Conditional Formatting for Total and Subtotals in Matrices

This has to be added

's profile image Profile Picture

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

RE: Conditional Formatting for Total and Subtotals in Matrices

This Feature is very necessary, please consider incorporating this. Thank you!

's profile image Profile Picture

Purushotam Bhardwaj on 05 Jul 2020 23:35:33

RE: Conditional Formatting for Total and Subtotals in Matrices

This Feature is very necessary for business analysis. please add this as soon as possible

's profile image Profile Picture

Nerys Jones on 05 Jul 2020 23:35:32

RE: Conditional Formatting for Total and Subtotals in Matrices

Yes please, I currently have to export info from PowerBi to excel for a particular weekly report to get around this problem