Forum Discussion

ShaneL79's avatar
ShaneL79
Helper I
6 years ago
Solved

Slicer Problems

I have a report with 6 pages (tabs). On this report there are two separate slicers thanks to two separate contractors who basically disagreed with each other to the point of building it this way befo...
Need Help
  • ShaneL79's avatar
    ShaneL79
    6 years ago

    Problem Solved:

     

    While the slicer was selected, I clicked "View" and "Selection Pane". This brought up a list of items on the page, including 2 slicers per page (one hidden, one visible). I am uncertain how there were two on each page (excluding the first page), but there were. 

     

    I determined that Slicer 1 was setup correctly and deleted the other from every page. This corrected the issue.

     

    Apparently there were two conflicting slicers working against each other.

     

    Thank you all for your help.

ShaneL79's avatar
ShaneL79
Helper I
6 years ago

Problem Solved:

 

While the slicer was selected, I clicked "View" and "Selection Pane". This brought up a list of items on the page, including 2 slicers per page (one hidden, one visible). I am uncertain how there were two on each page (excluding the first page), but there were. 

 

I determined that Slicer 1 was setup correctly and deleted the other from every page. This corrected the issue.

 

Apparently there were two conflicting slicers working against each other.

 

Thank you all for your help.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Can you send a picture of the relationships between your tables, focusing on the two tables you have shown and the table in question that is being filtered.