Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have a date slicer like this which consists of monthly dates with date being always 01 -
Goal: I would want slicer to automatically select the YTD months.
Example: Suppose if the current date or the refresh date is 1st May 2024, it should automatically select Jan to May month of 2024 and deselect the other months.
Please guide how this can be done.
Thanks in advance!
Solved! Go to Solution.
Hi,
Add this kind of column to your calendar table:
Then use that as a slicer:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi,
Add this kind of column to your calendar table:
Then use that as a slicer:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |