Date and Month slicer are not working on referenced table visuals

[Minakshi]

Hi All,

I have one flat table and other table is unpivot of this table. I am using multiple slicers from flat table to unpivot table. Established a many to many flat table to unpivot table relationship. All the slicer are working except Date and Month. Month column I extracted from Date itself.

Kindly help.

Thanks

[AllisonKennedy · Accepted solution]

Not sure why you are using a Many to Many relationship? This should be reserved for very specific scenarios. You need to try to find a unique identifier in the flat table to create the relationship with, or create one if it doesn't exist. You can use the Index column in Add Column in Power Query Editor to create a unique ID in the flat table, then duplicate or reference this for the unpivot.