Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a column called Variance. I need a color formatting for this column based on below
-5 to +5 as Green Color
-10 to +10 as Blue Color
-20 to +20 as Red Color.
I only see three options in conditional formatting Min,Max and Diverging.
Any help is appreciated.
Hi @pxg08680,
There are superpositions in your intervals. How to define the color of 0?
Such formatting isn't supported by now. Please vote or create a new idea here: conditional-formatting-intervals. Maybe there is a workaround.
1. Add a new Calculated Column like this:
Column = IF ( [Value] < -5, -1, IF ( [Value] < 5, 0, 1 ) )
2. Format it like this:
Best Regards!
Dale