dynamic reference line

[khadijabl2000]

How to set a reference line that automatically adjusts to the dropdown slicer in Power BI. If you select an item from the dropdown list, the line takes a specific value. For example: in my dropdown i have cities and the max of values changes if we change the city we look for if the item is 'Tokyo', the line value becomes 4, and if the item is 'Paris', the line value becomes 3. and on my X-axis i have date and on my Y-axis is value

[danextian]

Hi @khadijabl2000 

You can use a column and line combo chart and use the line as a reference (use a conditional measure for the line). Or you can add a constant line and click fx to select the measure. In the image below though, the value is manually inputted.

[khadijabl2000]

i did that but it doesn't work maybe i did something wrong 

[danextian]

What doesn't work? I can see that the reference line is at 1M which is true because you haven't selected New York.

[khadijabl2000]

here you can see that. when i select new york the line still in 1M. my bad I didn't send this screen earlier.