Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need a date slicer with some predefined values:
Upon selecting any of these values, the from and to dates should be automatically set. Can this be done?
Hi amalekshahi,
Put your date on slicer visual , and there is a dropdown arrow on the upper right corner of the visual. You can choose "Relative" . Then when you select the day, month ,year and numbers, the calendar slicer that you want will show.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-xicai but this is not the solution I was looking for. I am familiar with the relative option in date slicer but it isn't easy to use for beginners.
Hi @amalekshahi ,
Could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Amy
Also this filter will be set against the date dimension's date column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |