Forum Discussion
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 visual card ( in blue circle) can follow the color in tachometer? For example in the image below should be the value 46 red.
First source table with Actual and Targed values.
| Product Group | Hazard reported Actual | Hazard reported Target |
| A | 689 | 576 |
| B | 346 | 335 |
| C | 326 | 223 |
| D | 46 | 64 |
| E | 46 | 25 |
| F | 56 | 1 |
And the second table which is only for range definition in the Tachometer visualisation.
| Product Group | Hazard reported Range 2 | Hazard reported Range 3 | Hazard END |
| A | 460,8 | 576 | 864 |
| B | 268 | 335 | 502,5 |
| C | 178,4 | 223 | 334,5 |
| D | 51,2 | 64 | 96 |
| E | 20 | 25 | 37,5 |
| F | 0,8 | 1 | 1,5 |
Thank you very much for help
Jan
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.
4 Replies
- mahoneypat
Microsoft Employee
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
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
- v-robertq-msft
Community Support
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.
