Conditional formatting using Switch Function

[Anonymous]

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)))

[rajulshah · Accepted solution]

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.