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 >=21 and <= 30 # Amber
if >=31 # Red
Measure
% Mental Health = IF(DIVIDE([MentalHealthValues],COUNT(Case_Data[MentalHealth]),0)=BLANK(),0,(DIVIDE([MentalHealthValues],COUNT(Case_Data[MentalHealth]),0)))
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.
1 Reply
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.