Forum Discussion

Burubear's avatar
Burubear
Helper I
6 years ago
Solved

Team comparison using slicers both with same data charts

Hello to all   Hoepfully I'm asking in the right category. Just want to ask for a simple way wherein I  compare different teams using the same data set with a slicer.    I have these sample set d...
Need Help
  • BA_Pete's avatar
    BA_Pete
    6 years ago

    Hi Burubear 

     

    I had a very similar requirement to this in order to compare whole life costs between two vehicles from a single list.

    I solved it by selecting each slicer then using View > Edit Interactions. This allowed me to select which side of the comparison each slicer filtered.

    My output (not my prettiest work!):

     

     

    All the slicers on the left only filter visuals on the left and vice versa.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
6 years ago

Hi Burubear 

 

I had a very similar requirement to this in order to compare whole life costs between two vehicles from a single list.

I solved it by selecting each slicer then using View > Edit Interactions. This allowed me to select which side of the comparison each slicer filtered.

My output (not my prettiest work!):

 

 

All the slicers on the left only filter visuals on the left and vice versa.

 

Pete

Burubear's avatar
Burubear
Helper I
6 years ago

Thank you!

 

This really helps out a lot. Encoutered this solution with other post but most of the just refers to one slicer to 2 charts or 2 slicers to one chart. Was confused that if I click on "none" for the graph that it wont filter anymore but it's all clear now. Thanks a lot