Conditional formatting Totals with Gradient

[doriinatoth]

Hi, 

I am trying to add conditional formatting to a Matrix visual, I want to format the background as Gradient, going from Lowest value (red) to Highest value (green). Please see below the settings that I would like to use:

My issue is that I need this formatting to work on Totals as well, however when I change that the settings are to be applied to Totals, PowerBI wants me to input a customer number, it no longer has the option for Lowest/Highest value. Is there a workaround for this? 

Thanks!

[audreygerred]

Hi! Unfortunately, that is a known limitation: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#consi... 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#total...