Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Conditional Formatting: Number to Text

I have a column called "Projected Hour Variance" that shows a percentage. I have this on a card visual, but instead of the percentage appearing, I want to show text OR show a red/yellow/green dot. ...

v-xuding-msft
5 years ago
Hi Anonymous ,

Please try this:

Or create a measure:

Measure = var pro = MAX('Table'[Projected Hour Variance]) return IF( pro <=0 && pro >= -0.1,"Within Budget",IF(pro>=0.1,"Over Budget",""))
Conditional Formatting Number to Text.pbix23 KB

Super User

5 years ago

Anonymous ,

Try a below DAX measure:

Final Output = SWITCH(TRUE(),AND([Projected Hour Variance]>-10,[Projected Hour Variance]<=0),"Within Budget","Over Budget")

See this screen shot of expected output.