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]

hi @danextian Thank you for your time. Eventually it worked.

Best regards, 

Khadija 

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

[v-sshirivolu · Accepted solution]

Hi @khadijabl2000 ,
Thanks for sharing the screenshot that really helps. The reason your reference line is still showing 1M even after selecting New York is likely because the measure behind the line is removing the filter context, usually due to the use of ALL or a similar function. When ALL is used it ignores slicers like City so the line does not respond to your selection. To fix this you will need to update the measure so it respects the filter context.
For example Line Value = AVERAGE Sales Amount or using CALCULATE without removing filters. Also make sure you have applied the measure using the fx button in the Analytics pane instead of entering a static value. Once updated the reference line should dynamically adjust when you select different cities like New York or Boston. 

Please find the attached .pbix file for your reference.

Thank you.

[khadijabl2000]

Hi @v-sshirivolu, 

Thank you very much for your help. I used ALLSELECTED and it did work.

Best regards, 

Khadija