Grading a measure value

[msprog]

Hi

I am having a PowerBI dashboard.
One of the measures is called AverageResponseTime. I have a DAX measure to compute this.
Now, i have been given some Grading for this AverageResponseTime.

IF AverageResponseTime<5 , then SUPERIOR,
IF AverageResponseTime>5 and less than 60, then FAIR
IF AverageResponseTime>60, then POOR

Currently I am showing the measure value on a Card. But I would like to display Good or Fair or Poor,

Remember the measure can be computed on a daily, monthly or quarterly basis depending onthe date filter. 

How can i achieve this in PowerBI, are there any features/visual that i can use?

Please help

thanks

[JosefPrakljacic · Accepted solution]

Hey @msprog,

I hope I have understood you right.

So you have a Measure thats already telling you a certain response time?

Now you want to have a card visual which is showing a representation in text format - Poor, Good, Whatever?

I would create another Measure like this

Measure =
SWITCH (
    TRUE (),
    [ResponseTime] < 0.2, "poor",
    [ResponseTime] < 0.4, "meh",
    [ResponseTime] < 0.5, "yay",
    "nothing"
)

And put it in a card visual - then i would add some conditional formatting to create a "semaphor" and thats it 🙂

If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

Have a nice day!

BR,
Josef
Graz - Austria

[msprog]

Thanks a lot. I will try this
Please cN you explain conditional formatting and semaphore. I am a bit confused on that
Thanks

[JosefPrakljacic]

In that 4 min video you can see what I've meant 🙂