Adding % format to card visual measure with conditional formatting

[hobosapien]

I have applied conditional formatting to a measure that's being used in a basic card visual. However, if I attempt to format this by enclosing the measure in FORMAT() the conditional formatting doesn't like that it is now in a text type instead of a number. How can I simultaneously format this to show as 95.85% and have conditional formatting at the same time?

Measure: AVG EVAL = CALCULATE(AVERAGE(f_EvaluationScores[Score]),FILTER(d_Dates,d_Dates[Year]=2024))

[danextian · Accepted solution]

Hi @hobosapien 

Question: why is your measure more than 1. If formatted to percentage that would be 9585% and not 95.85%. That aside, select the measure and then format it to % from the contextual tab that will appear. Also, if you need to show 95.85%, modify your measure to this:

AVG EVAL =
DIVIDE (
    CALCULATE ( AVERAGE ( f_EvaluationScores[Score] ), d_Dates[Year] = 2024 ),
    100
)

[hobosapien]

Ah - I see. I was selecting the card and thinking the % formatting should be there, but I needed to select the measure instead and that's where I went wrong. Thank you for the other suggestions too.

[danextian]

There is visual level formatting available in the card as well. This will override the semantic-model wide formatting applied to the related measure.

[Ashish_Mathur]

Hi,

Just select the measure and click on the % age symbol button in the ribbon.  Furthermore, you can simplify your measure to:

AVG EVAL = CALCULATE(AVERAGE(f_EvaluationScores[Score]),d_Dates[Year]=2024)