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.
Hi and thanks for reading,
How can I create three single-click selectors (slicer?) that filter the date range on my report by last 12 months, current fiscal year to date and last month?
Thank you!
Will
Solved! Go to Solution.
If you add a date field to a slicer, you can turn on relative date filtering after you add a field with dates to the slicer using the little arrow. You can choose to have it show the last 12 months based on today. You'd then add another slicer with the same date field and turn on relative date filtering again and then choose "Days" and put 30. As far as the fiscal year, that requires additional programming and there are a whole bunch of topics on that if you do a search.
If you add a date field to a slicer, you can turn on relative date filtering after you add a field with dates to the slicer using the little arrow. You can choose to have it show the last 12 months based on today. You'd then add another slicer with the same date field and turn on relative date filtering again and then choose "Days" and put 30. As far as the fiscal year, that requires additional programming and there are a whole bunch of topics on that if you do a search.
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 |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |