Forum Discussion
msprog
6 years agoAdvocate III
Grading a measure value
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 A...
- 6 years ago
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
6 years agoAdvocate III
Thanks a lot. I will try this
Please cN you explain conditional formatting and semaphore. I am a bit confused on that
Thanks
Please cN you explain conditional formatting and semaphore. I am a bit confused on that
Thanks
JosefPrakljacic
6 years agoSolution Sage
In that 4 min video you can see what I've meant 🙂