Forum Discussion
Date Slicer
Hi LearnPowerBIAS,
#1, AFAIK, slicer does not support setting default values. You can try to create a custom table based on calendar function and use today function as end date. Then you can use new table date field as source of slicer, and it will show the today's date as the slicer end date.
CALENDAR function (DAX) - DAX | Microsoft Learn
#2, In fact, the slicer not able to affect the report generate. I'd like to suggest you add query parameters and use them to filter the backend query tables and saving the report as the template. After these steps, you can modify the query parameters to generate reports with different ranges.
Regards,
Xiaoxin Sheng
Hi LearnPowerBIAS,
#1, AFAIK, slicer does not support setting default values. You can try to create a custom table based on calendar function and use today function as end date. Then you can use new table date field as source of slicer, and it will show the today's date as the slicer end date.
CALENDAR function (DAX) - DAX | Microsoft Learn
#2, In fact, the slicer not able to affect the report generate. I'd like to suggest you add query parameters and use them to filter the backend query tables and saving the report as the template. After these steps, you can modify the query parameters to generate reports with different ranges.
Regards,
Xiaoxin Sheng