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 A...
  • JosefPrakljacic's avatar
    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