Help with date slicer

Hi Anonymous ,

It seems you're looking to create a date slicer in Power BI that allows users to select from predefined date ranges as well as a custom date range.

You can create a relative date slicer.

This feature allows you to apply a time filter to any date column in your data model.

I think this function is more convenient. You don't need to create a date range table, but you can also select the corresponding date range.

For more information about relative date slicers, please see:

Create a relative date slicer or filter in Power BI - Power BI | Microsoft Learn

If this method does not solve your needs, maybe you can try uploading your pbix file to me. Please be careful not to log in to your account in Power BI Desktop when uploading the pbix file.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!