Date Time Slicer allowing invalid values

[ThuTa1997]

Dear Community, I have a problem with PowerBI Slicer (Date Time) , that the Calendar popup allows user to chose any date/time they can without restricting to only valid dates in the dataset. Pls help us how we can solve that ???

With Regards

Thu Ta Naing

[v-zhenbw-msft]

Hi @ThuTa1997 ,

What does the table that your date time belong to?

If you use the date time that from your fact table, the slicer will show the valid dates in the fact table.

You need to create a new date table, then create the slicer using the new date table.

You can change the range of the date in the CALENDAR function.

If it doesn’t meet your requirement, could you please show us the expected result?

Best regards,

Community Support Team _ zhenbw

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

[ThuTa1997]

Hello Someone, pls help to this question, any solution ??