Forum Discussion
Conditional formatting using Switch Function
Hi Experts How would you use the switch function with the following measure based on the following criteria to conditional format data based on the following if >= 0 and <= 20 #Green if >=2...
Hello Anonymous,
You can create a calculated column as:
CalculatedColumn = IF ([Measure] >=0 && [Measure]<=20 , "*color code of green*",IF([Measure]>=21 && [Measure]<=30,"*color code of amber*",IF([Measure]>=31,"*color code of red*")
Then use conditional formatting on field values for the created calculated column.
Hope this helps.
Let me know if this doesn't work.
Hello Anonymous,
You can create a calculated column as:
CalculatedColumn = IF ([Measure] >=0 && [Measure]<=20 , "*color code of green*",IF([Measure]>=21 && [Measure]<=30,"*color code of amber*",IF([Measure]>=31,"*color code of red*")
Then use conditional formatting on field values for the created calculated column.
Hope this helps.
Let me know if this doesn't work.