Forum Discussion
Post ProdigySlicer with date range (From date) not updated automatically
I have my report scheduled to be refreshed everytday at Power Service (app.powerbi.com).
(BTW, I have posted this question previously, but I did not get the solution, so I am posting again)
But, I realized that From date at my Slicer that does not get updated automatically.
What is solution to have this From date range to be updated by itself?
To date gets updated because I slide all the way to the current date, but From date does not get updated.
Bottom are screenshots of my slicer:
Thanks.
5 Replies
HashamNiazSolution Sage
Hi JustinDoh1 !
Please try switching to Relative date slicer mode;
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Seems you are looking for something like, Last 7 or 30 days to be your date range. You can use relative date slicer for that purpose.
Regards,
Hasham
- JustinDoh1
HashamNiaz I just updated the image on my original post.
Actually, I am using Relative date, and it still doe not update correctly.
- HashamNiaz
Hi JustinDoh1 !
You can change the slicer layout between (List, Dropdown, Range, Relative), see the image below. Also you can then remove visual level filter on your slicer. You need to use Date element as Date rather than Date hierarchy for this option to be visible in Date slicer. Then from slicer hearder choose the dropdown icon & change it to relative date.
Relative Date
Regards,
Hasham
HI - i am having same issue. did you find any solution
