Date Slicer Only Displaying Minutes and Hours In Drop Down Select

[Anonymous]

As title says, I created a date slicer from a date field, but the drop down selection is only showing Minutes and Hours, not Days, Months, Years as it typically does.

for reference;

[v-jinweili-msft · Accepted solution]

Hi @Anonymous ,

According to your screenshot, It seems that you have selected the Relative Time option.

So please select Relative Date instead, and then you can choose Days, Months, Years......

Best Regards,
Jinwei Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy]

@Anonymous Confirm that the data type has been set explicitly to Date in Power Query and that it's also formatted as a Date in the data model?