Forum Discussion
Date Slicer
Hi Friends,
I have 2 questions:
1. How to show fiscal year (Eg. 09/01/2022) as start date and CURRENT date as End date in date slicer?
2. I have another date slicer where I should not show the Between values if they open the report. (Basically the slicer date should be empty, the user need to type the date to generate the report).
TIA
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
1 Reply
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