Please need help making a Dynamic Line in my line Chart

[Anonymous]

I have a line chart showing accumulated exports by year for different countries. The line chart has a constant line that shows the projeted total we are trying to meet. Here is a picture of an example below. I would like to have that when I select another country the Constant line moves accordingly. I know how to do this with adding another value the thing is I have a legend in my chart and you cant have two values with a legend in Power Bi.

[V-lianl-msft]

Hi @Anonymous ,

The value of constant line is determined by a constant value and cannot be changed by the slicer.

I would suggest you create a measure and then drag the measure to the chart.

Try DAX like this:

Measure = SELECTEDVALUE ( sheet1[value] )

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

[Anonymous]

Thanks for your reply. Here is my project now are you saying I will be able to drag another measure to the values section. It wont let me add another one when I have a legend