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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Probably, but will need more information. What columns are these slicers tied to? The same column or different columns? This will likely come down to how the data model and underlying columns are constructed, relationships, etc.

 

This one is going to come down to implementation so sharing the PBIX would be helpful or at least as much information as possible.

ShaneL79's avatar
ShaneL79
Helper I
6 years ago

Thanks for the response. I have some confidential information in the PBIX so sending it isn't possible, I don't think. 

 

I am willing to take screenshots of anything you want, if that would suffice.

 

As for the columns, here is what I have:

 

Slicer 1 uses "MonthEnd" which is a formula using MonthEnd = EOMONTH ( [date], 0 )

Slicer 1

 

 

Slicer 2 uses "End of Month" which is a date column. It gives dates in this format "Saturday, February 29, 2020"

 

Slicer 2