Tachometer visualisation and different card color

[Anonymous]

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

[v-robertq-msft · Accepted solution]

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")

2. 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.

[Anonymous]

Dear @v-robertq-msft 

that is perfect - what I had been looking for.

Thanks a lot

Jan

[mahoneypat]

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

[Anonymous]

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