Color Change in Line Chart based on Slicer Value

[carlol]

I have a Funnel Plot Chart I created in DAX , the Blue dots represent the Percentage , based on a single slicer selection ; I want to change the Dot to red for the given select and still illustrate the remaing DOTS in blue 

I was looking at using a copy of the chart with red Dots  and super inposing it on top of the Blue dotted chart (Bring to Front) , edit the interactions of the Silcer to only alter the red dotted chart; but this has its issues , when you select one Slicer value you loose the full range of your X axis and the scale is not on par with the first chart (Blue dots) , red dot is not sitting excatly on its Blue dot counter part ; it is a hack 

Anybody any idea's?

[carlol]

File 

https://1drv.ms/u/s!Ao-FTTt3GMhriIoob6xyvtm3IK4w1Q?e=Zi0rBG

[V-lianl-msft · Accepted solution]

Hi @carlol ,

You're right. Maybe it's a lack of function,you can submit your idea to help improve power bi.

https://ideas.powerbi.com/ 

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

[carlol]

Thanks for the help Liang 

Will submit the idea

[carlol]

Thanks 

I need to retain the 4 values I am using with a line an cluster chart control , the solution only appears to work if I use one Value and a stacked Chart control 

Do we have any other options ?

[V-lianl-msft]

Hi @carlol ,

You need to create a new table and use one of its column as a slicer.

Then create a measure to dynamically change the data color.

Try to use DAX like this:

Measure=  IF(VALUES(Table2[value]) IN VALUES (Table1[value]),"#ff0000")

If the problem persists,could you please share sample data or pbix?(Please mask any sensitive data before uploading)

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