Slicer Problems

[ShaneL79]

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 before the funding dried up. 

The Problem:

Slicer 1 is only visible on Page 1. Slicer 2 is visible on Pages 2 - 6. 

Both slicers are using a drop down that gives the last day of every month as an option. They show all months since the beginning of our database. 

Slicer 1 works for all date ranges. 

Slicer 2 only works for 2020 dates.

Slicer 1 uses the filters (Date = relative date filter in the last 3650 days including today), and MonthEnding is (All).

Slicer 2 uses the filter (End of Month is (All)

In the slicer sync table, the following are checked for each:

Slicer 1: Page 1 only has "Visible" checked.

Slicer 2: Pages 2 - 6 all have "Visible" and "Sync" checked.

I tried using both slicers together. This works as long as the same month is selected.

I tried using slicer 1 only. This worked for older data, but broke the connection to anything in 2020.

I tried using slicer 2 only. This worked for 2020 data, but nothing before 2020.

I'm at a complete loss and am willing to start over if a fix isn't simple. 

What I want is to have a drop down that has one entry for every month (the last day of the month). A single slicer on page 1 would be sufficient as long as it updated the data on every other page. 

Can anyone help me?

[ShaneL79 · Accepted solution]

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]

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.

[Anonymous]

HI @ShaneL79,

It will help if you explain more about your scenario or share a sample pbix file to test.

For example:

Did these slicers use the same table fields? How did the interact setting between these slicers and visuals?

If they are from different table fields, did these tables linked? How relationship mapping?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[ShaneL79]

Thank you for the response. 

I have added a comment below with more detail, but unfortunately no PBIX due to the sensitivity of the data. 

I can grab screenshots of anything you think would be best to help you help me. 

[Greg_Deckler]

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]

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