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.
You can use conditional formatting on the Data Label of the card visual using a measure like the one below. Set the color to this as the "Field Value.
FontColor =
VAR result = [YourMeasure]
RETURN
SWITCH ( TRUE (), result < 60, "Red", result < 80, "Yellow", "Green" )
Pat
- Anonymous5 years agoNot applicable
Hello Pat,
thank you for your reply. Does this work also if I use filter and switch to "Product group" B - there is a targed 335 and actual 346 - that meas it shoudl be green?
Therefore I want to set up range for all visuals - for example below 60% red, 60 - 80 yellow, 80 - 120% green. The target changes using filter with "Product group".
Jan