Line chart with dynamic goal to compare

Hi Anonymous ,

I think you can use the bookmark function to make it.

Create 2 charts and 2 bookmarks for each chart.

And when you click the first value of the indicator slicer, do bookmark 1, show chart 1.

click the second value to do bookmark 2 and show chart 2.

And chart 1 and chart 2 can have a different constant line.

Please try.

Aiolos Zhao

Hi Anonymous ,

To make bookmarks work for every selected options, you may refer to the articles: Use bookmarks to share insights and build stories in Power BI , Dynamic Visuals using Buttons, pay attention to the detail.

In addition, you may also create measure like DAX below to include the effect of slicer filter, and put the measure to chart line.

Measure1= CALCUALTE(SUM([Value]), ALLSELECTED(Slicer[selection]))

Best Regards,

Amy 

Community Support Team _ Amy

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