Multiple Slicer on the same Graph

[tomshaw83]

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

[Anonymous · Accepted solution]

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.