Forum Discussion

AutyDA's avatar
AutyDA
Icon for Helper I rankHelper I
2 years ago

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

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?

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      AutyDA
      Icon for Helper I rankHelper I

      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's avatar
        Anonymous
        Not applicable

        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