Conditional Format % using FORMAT() function

[pbi_baller]

Hi All,

I have a dax measure using a SWITCH() statement. Sometimes the result will be a whole number and sometimes a percent. I am using the FORMAT() function when obtaining a %.

The only issue is when applying conditional formatting to the measure, it is not applied to any result diplaying x%. I am guessing becasue the format function is displaying text not a number?

Does anyone know a solution or work around for this?

[v-xinruzhu-msft]

Hi @pbi_baller 

You can refer to the following example

Sample data 

Measure 1

Measure 3 = IF(SELECTEDVALUE('Table'[Column2])>=0.5&&SELECTEDVALUE('Table'[Column2])<=2,SELECTEDVALUE('Table'[Column2])*100&"%",SUM('Table'[Column2]))

Then create a formatter measure

Measure 4 = var a=IF(CONTAINSSTRING([Measure 3],"%"),CONVERT(LEFT([Measure 3],SEARCH("%",[Measure 3],1,BLANK())-1),DOUBLE)/100,[Measure 3])
return IF(a>=10,"red",IF(a>0.5&&a<2,"blue","green"))

Then put the measure to the conditional formatting

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.