Forum Discussion
Tachometer visualisation and different card color
- 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:
- 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")- 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.
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:
- 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")
- 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.
- Anonymous5 years agoNot applicable