Slicer for selected month showing additional months data

[Anonymous]

Hi, 

I require assistance. 

I have slicer applied to my visuals with Date Hierachy (Year, Month, Day) but when I select a specific month, Other months data pull thorugh as well but when I apply the filters using specific dates, the correct data is displayed. How do I fix the issue on the slicer?

See screen below showing the Slicer applied to May but data for Dec and Jan reflecting

See screen below showing Dates applied for June reflecting the correct data

[Anonymous]

You can't mix columns. If you use a column from a Date table, then you can't use a Date column from a different table and expect this to work correctly. The rule is this: slicing and dicing is done only through dimensions and all columns in fact tables are hidden.