Charting a dynamic range and highlight a selected data point within the range

[AutyDA]

Hi, I have data for various companies. I want to select several of these, maybe using a slicer, and create a max and min of the selected data for each year. From the same set of companies I then want to select one of them and chart this to show where it fits in the range. The end chart will look something like this:

Here is a sample of my table

I've tried using a slicer to select the Company No's (column 1) I wish to determine the range using a slicer (top right slicer). Then I created measures to determine the range of data from my last column of data using "Global Revenue MAX = MAX(Sheet1[Global Revenue])" and Global Revenue MIN = MIN(Sheet1[Global Revenue]). I can chart this as an area chart to show a range (see bottom left chart).

My problem is I can not find a way to select and chart the position of the selected company within the range (the grey line in the example chart). I try using a slicer to select the data I want to choose but that creates problems because of the slicer I used earlier.  

Any ideas what is the best way to do this?

[Anonymous]

Hi, @AutyDA 

You can use the Edit Interaction feature to uninteract slicer 2 from line chart 1.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[AutyDA]

Yang, this helps but it's not quite there.

The slicer in the bottom right impacts the max and min measure calculations on Global Revenue by effectively filtering them to the companies selected here. The idea is that only the slicer on the top right should affect these measures. Any ideas?

[Anonymous]

Hi, @AutyDA 

Somewhat missing your point, which visual object is affected by the 1st slicer and the 2nd slicer respectively? You could be more specific.

Best Regards,
Yang
Community Support Team