Month Slicer does not work with 1 visual

[Riddlemirror]

Hey Community,

I have a data that is to be sliced via the Monthly Slicer. I have all of the visuals working except for one table. I have looked into the relationships but I cannot seem to figure out what I did wrong.

The Month column exists in the original dataset and I have it formatted to the same format. 

I have also tried to create a separate Month Reference Table and connected it to all my other datasets. Again, it works for every one of them except this one called "All GPC Cases".

Screenshots below:

(Problem dataset highlighted in Red)

MonthTable is the reference table which is filtering all other datasets.

Month column in the "All GPC Cases" 

All visuals are filtered for the month except for this table "All GPC Cases" which shows cases per country:

[ribisht17]

Yes, I was quite sure that it was a data issue 🙂

[ribisht17]

Hi ,

It is difficult to tell without seeing the actual data model from here.

Can be a data corruption issue with PBI and workbook. Have you tried to recreate it?

Regards,

Ritesh

[Riddlemirror · Accepted solution]

Actually i changed the data sets a bit now for the visualizations. And I realized I had some redundancies in my datasets. SO Now I have deleted one of them and used a slicer directly from the 'All GPC Cases' dataset which worked on all other datasets too. So Not sure what the issue was but I found a workaround 🙂