Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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