Forum Discussion

Erin's avatar
Erin
Icon for Helper I rankHelper I
10 years ago

Interaction between two Slicers doesn't work well

Hi All,   I have two slicers(S1 and S2) with some visuals on one report , S1(City) and S2(Product), and S1 can control S2 but S2 can't control S1. S1 and S2 can control all other visauls. The inter...
Need Help
PavelR's avatar
PavelR
Icon for Solution Specialist rankSolution Specialist
10 years ago

Hi Erin, what about your relationships between the tables? I mean those single/both cross filter directions?

 

I guess that there is single cross filter direction from the city table (S1) to the fact table or the relevant table.

 

Regards.

Pavel

Erin's avatar
Erin
Icon for Helper I rankHelper I
10 years ago

Hi Pavel,

 

I actually have one table as the data source to this report. Both City and product are columns in this table.

 

Thanks!

  • PavelR's avatar
    PavelR
    Icon for Solution Specialist rankSolution Specialist
    10 years ago

    I tried on test data as you described and already I see the bug.

     

    For others:

    Visualisation of bug:

     

    Sample table:

     

    Pavel

    • Erin's avatar
      Erin
      Icon for Helper I rankHelper I
      10 years ago

      that's what I get! Thanks!