Forum Discussion
dynamic reference line
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.
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.
i did that but it doesn't work maybe i did something wrong
What doesn't work? I can see that the reference line is at 1M which is true because you haven't selected New York.
here you can see that. when i select new york the line still in 1M. my bad I didn't send this screen earlier.
