Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multiple lines in line graph based on multiselect slicer

Hi all,

 

I want to create a line graph that shows multiple lines of data based on what is selected in a multiselect slicer.

 

On my x-axis, I have quarter, and on my y-axis I have number of sign-ups. I want the legend to be location, such that the graph shows a line for each location based on a slicer selection to allow people to compare the number of sign ups for different locations. The reason for wanting to have a slicer rather than just allow a full legend is that I have about 200 locations, so I want people to be able to select which locations are of interest to them.

 

Currently, if I create a line graph and allow multiselect for the slicer, it shows one line that simply aggregates the data for the multiple options I've selected. Is there a way to keep the lines distinct for each location and have them plot separately?

 

I'm new to Power BI and DAX, so any help would be much appreciated.

 

Thanks in advance for any help.

  • Anonymous , If you put qtr on axis and location on the legend and filter legend, it should respond to that. I am not clear.

    Each time you add a location a new line should come

2 Replies

  • Anonymous , If you put qtr on axis and location on the legend and filter legend, it should respond to that. I am not clear.

    Each time you add a location a new line should come

    • Anonymous's avatar
      Anonymous
      Not applicable

      Ahh thank you, that works. I knew it had to be something simple I jut couldn't figure out what! Thanks again.