Date not letting me select what values for slicer

[Anonymous]

Hello.

I have a power bi that I have used for the last months for my plant. I wanted to add some more data for other people to use, but after adding some relationships between different table dates, it has removed my selection for every date value. IE, I cannot select Quater, Month, Year, Day etc...

I have disabled all relationships and enabled just previous ones, and still no luck on getting them back. Any help would be really appreaciated.

[vicky_ · Accepted solution]

Did you create any relationships between that date field and another unique date field (like a calendar table)? if so, that removed the heirarchy on the M side - read here for more details: https://community.fabric.microsoft.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682....

Basically, the solution for that is to use the calendar table's date heirarchy in the filter.