Forum Discussion

msprog's avatar
msprog
Advocate III
6 years ago
Solved

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 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

Need Help
  • JosefPrakljacic's avatar
    JosefPrakljacic
    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

     

3 Replies

  • JosefPrakljacic's avatar
    JosefPrakljacic
    Solution Sage
    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's avatar
      msprog
      Advocate III
      6 years ago
      Thanks a lot. I will try this
      Please cN you explain conditional formatting and semaphore. I am a bit confused on that
      Thanks