Forum Discussion
Post ProdigyGraph does get adjusted automatically to the Date Slicer
Microsoft EmployeeWould it work if the user had to clear that filter on the Lastest 2 Weeks before they changed the date slicer? If so, they could do that in the filter panel, with a button/bookmark, or a slicer on the report page. I'm not sure there is a way around the user having to clear that filter somehow.
Pat
Post Prodigymahoneypat Thank you so much for your help. I think I am at the point I kinda had to give up on automatic way that visual or data range would work without user manually clears the filters. I am just trying to understand why other people mentioned about using a separate date field (like this post) as well. Two people said it is the best practice. I am curious. Thanks.
- mahoneypat
I looked at the post you linked, and they suggested a separate date table, which is what I assumed you had (and provided that expression to make a colum on it to make filtering to the last 14 days easier).
To get the 14-day range, that filter needs to be set somehow (and could filter both the slicer and the visual), and to go outside of that range the user would need to clear it somehow. The easiest way would be with a button associated with a bookmark.
Pat
- JustinDoh1
Thank you for your feedback.
I think using a fixed "last-14 days column" (by creating a calculated column) works on the visual only because it has an option to clear the filter.
But, when I tried with the fxied 14 column on the Date Range and published it, it would not give me an option to clear the filter. So, I had to use "Ralteve date" filter.
Either way, I realized that user has to manually clear the both filters (for visual and and for datea range) to see the data out of last 14 days.
Please see the bottom images for description:
This is Pbix file using only Relative date on the Date Range filter.
This is Pbix file using "fixed last 14 (or 16) days calculated column" on the Date Range filter.
At this point, my initial issue with Visual filter is not relative anymore.
I am just curious why "clear filter" would not work when I add the calculated column on the Date Range.
Thanks.