Skip to main content
Microsoft Idea

Power BI

Needs Votes

Conditional Formatting doesn't applied to a grand total values in matrix

Vote (66) Share
Antonio Garcia's profile image

Antonio Garcia on 23 Feb 2018 19:55:22

It will be very interenting that this option was implemented. When the users analyze data in matrix they want to have the option to applied the conditional formatting in the grand total level.

Comments (18)
Antonio Garcia's profile image Profile Picture

Marcus Allen on 06 Apr 2023 19:30:17

RE: Conditional Formatting doesn't applied to a grand total values in matrix

It works now for some types of conditional formatting, but for some reason it still isn't an option for data bars.

Antonio Garcia's profile image Profile Picture

on 08 Jun 2021 16:23:08

RE: Conditional Formatting doesn't applied to a grand total values in matrix

I think it would be great if conditional formatting coloured the Total Rows

Antonio Garcia's profile image Profile Picture

on 10 Nov 2020 00:44:58

RE: Conditional Formatting doesn't applied to a grand total values in matrix

An option to conditionally format Sub-total columns and rows.

At the moment my values are conditionally formatted but but the sub-totals are bare as they can't be formatted.

Antonio Garcia's profile image Profile Picture

Paul Moldmann on 19 Aug 2020 08:43:01

RE: Conditional Formatting doesn't applied to a grand total values in matrix

conditional formatting should be possible to be applied for totals and subtotals as well. But have in mind that size or boldness of text should be formatable separatedly from the matrix value.

I need this feature to color negative values as red and positive ones as black - not only for the cell values, but also for totals and subtotals. But still, totals and subtotals should be displayed in bold digits.

Antonio Garcia's profile image Profile Picture

Hrishi on 06 Jul 2020 00:08:33

RE: Conditional Formatting doesn't applied to a grand total values in matrix

This is coming in July 2020 release looks like

Antonio Garcia's profile image Profile Picture

Emanuel Avalos on 05 Jul 2020 23:56:09

RE: Conditional Formatting doesn't applied to a grand total values in matrix

Please we need this you just added the icons for the conditional formatting in matrix but is not in total rows!! Totally Need this!

Antonio Garcia's profile image Profile Picture

Power BI User on 05 Jul 2020 23:55:13

RE: Conditional Formatting doesn't applied to a grand total values in matrix

Yes we need it!

Antonio Garcia's profile image Profile Picture

Power BI User on 05 Jul 2020 23:52:44

RE: Conditional Formatting doesn't applied to a grand total values in matrix

I agree to , we need on totals and subtotals

Antonio Garcia's profile image Profile Picture

Suyog S Patil on 05 Jul 2020 23:47:41

RE: Conditional Formatting doesn't applied to a grand total values in matrix

Did we get any update on this idea? Waiting for this to get as an Feature and publish critical report.

Antonio Garcia's profile image Profile Picture

Fla on 05 Jul 2020 23:43:04

RE: Conditional Formatting doesn't applied to a grand total values in matrix

we need contidional formatting in all visuals TOTALS for the negative values.

Merged Idea (1)