Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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
In that 4 min video you can see what I've meant 🙂
User | Count |
---|---|
92 | |
86 | |
66 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |