Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am having problem with setting the date range slicer dynamic.
That's the slicer below:
Solved! Go to Solution.
Try if you can use :https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
@kormosb ,
The relative date slicer may meet your requirement:
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, unfortunately no.
Benjamin
I found an article which talks about a workaround for this problem. I think this is by far the best way to address this particulat issue.
To summarize the solution, use a combination of a "Special Dates" table which is similar to relative date slicer, but with an additional value to choose "custom". Upon choosing "custom", a bookmark will appear which allows you to choose the "Date Range".
Below a demo GIF extracted from the article mentioned above.
@kormosb ,
The relative date slicer may meet your requirement:
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I want to restrict my date slicer selected start to end date should be 30 days dynamically, can you help me on this issue.
example : i have selected 15st august 2022 end date should be 13 th August 2022.
Try if you can use :https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
User | Count |
---|---|
93 | |
85 | |
76 | |
67 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |