Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Tachometer visualisation and different card color

Hello,   I am preparing visualisation - visual type: "Tachometer" which shows actual  value. I defined in the tachometer ranges, which are separated by color.    Are there any options whether the...
  • v-robertq-msft's avatar
    5 years ago

    Hi, Anonymous 

    According to your description, I can roughly understand your requirement, and I think you can explain the logic of your Tachometer visual in detail if it’s possible. You can follow my steps:

    1. Create a measure like this:
    Color =
    
    var _actual=SUM('Table'[Hazard reported Actual])
    
    var _target=SUM('Table'[Hazard reported Target])
    
    return
    
    SWITCH(
    
        TRUE(),
    
        _actual<_target*0.6,"Red",
    
        _actual>=_target*0.6&&_actual<=_target*0.8,"Yellow",
    
        _actual>_target*0.8&&_actual<=_target*1.2,"Green")
    1. Click on the card visual and apply the custom color like this:

     

    And you can roughly get what you want, like this:

     

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.