Prevent conditional colour formatting changing when data is filtered

[Anonymous]

I have a table of data. I have 'Background color' conditional formatting applied to the numerical values - a colour scale from dark green (highest) to light green (lowest) based on the numerical value. 

When the table is filtered, the value does not change but the colour changes to the darkest available green from my scale. 

Any way to make the colour stick?

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you😀

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

Hi @Anonymous ,

As you said, applying filter will cause Conditional formatting to change accordingly. 

So my workround is Custom the lowest and highest value like this:

Please take a look at the differences here:

But this is at idea/feedback level alone. You could let the power bi community to know this things and give your votes at power bi site's feedback -https://ideas.powerbi.com/ideas/

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Not very sure. create a rank with all and try to color on that.

Somthing like this

Rankx(all(Table), [measure],,desc)

[Anonymous]

Hi @amitchandak 

I tried the measure, the colour changes still - and also the value of the rank don't really mean anything to my consumer! It seems strange PBI hasn't got a solution for this - heat maps are great to compare a category, but if you want to see a single value... the heat map colours are still relevant.