Forum Discussion
Prevent conditional colour formatting changing when data is filtered
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?
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.
4 Replies
Anonymous , Not very sure. create a rank with all and try to color on that.
Somthing like this
Rankx(all(Table), [measure],,desc)
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.
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.
