Forum Discussion

tomshaw83's avatar
tomshaw83
Helper I
3 years ago
Solved

Multiple Slicer on the same Graph

Hi,

 

I am looking to produce a single line graph visual, which responds to 2 sets of independent slicers. 

 

So a line would be produced for the selections from the first set of slicers, then a separate set of slicers would be produced for the second set. I've considered copying the tables so the full data set is available to each slicer - but I don't know how this can then be merged so the data appears on the same visual.

 

Apologies if I've not explained this well, the essence is to compare 2 things on the same graph, but not have the first thing filtered out by the first set of slicers.

 

Any help would be appreciated

 

Thanks


Tom

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi tomshaw83 ,

     

    Did you mean you want slicer A to filter line A in line chart A, and slicer B to filter line B in line chart B, right?

    It is recommended that you create two tables with slicer fields for the two slicers of these two lines, and then write a filter measure for the visual-level filter.

     

     

     

    Best Regards,

    Stephen Tao

     

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi tomshaw83 ,

     

    Did you mean you want slicer A to filter line A in line chart A, and slicer B to filter line B in line chart B, right?

    It is recommended that you create two tables with slicer fields for the two slicers of these two lines, and then write a filter measure for the visual-level filter.

     

     

     

    Best Regards,

    Stephen Tao

     

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