Forum Discussion
Post ProdigyDate range slicer (or other data range user interface) to be updated automatically
I am posting this question again (3rd time) because I did not get solution for my issue.
I am trying to apply Date Range slicer as below, and I would like this to be updated automatically.
The point is, it does not have to be exactly same user interface as a 'slicer', but as long as user can input date range, that would fulfill the requirement. But, I would like the date ranges that show up automatically updated when there is a data refresh.
In this case, I would like to have 14 days date range interval from today reflected automatically when there is a data refresh.
I have a "Filter on this visual" coded so that it does get updated fine:
The issue is Date Range for user does not get adjusted for the date interval of 14 days automatically.
Is there other way to get this done (with that slicer or using other method)?
Thank you!
11 Replies
- mwegener
Most Valuable Professional
Hi JustinDoh1,
have you enabled the following option?
"Don't allow end user to save filters on this report."
- JustinDoh1
mwegener Not sure how/whether it would suffice my requirement, but I just enabled it and republished to the service. But, would't it just the feature for report to stay where they were left off (by not having the option of going back to a default mode)? My requirement is having the date ranges automatically updated 14 days interval. Let me check tomorrow when data refreshs to check whether it makes sense or not. Thanks.
- JustinDoh1
mwegener I liked using "Relative date" filter (compared to using measure of last 14 days) as it has the option of "Clear selections". Only issue that I have is that the actual visual (or graph) does not reflect those date range (I guess since I cleared the selection). As you can see (on the bottom image illustration), it starts from the very beginning of data (early 2020). Reason I cleared the selection was so that this date range would be updated dynamically (for instance, it would be 7/3/2021 - 7/14/2021 tomorrow), correct? It is little bit not making sense why this date range would not be updated by itself if we do not clear the filter. Is there a way for graph be reflected based on the filter, and also date range be updated dynamically? Thanks.
- JustinDoh1
mwegener I was expecting the date range starts from 6/29/2021, but it still stays at 6/28/2021 this morning (after daily data refresh). I don't think it would suffice my requirement... Thanks!
- mwegener
Hi JustinDoh1 ,
is the selection cleared on the slicer?It is important that the slicer has not saved any preselection and only displays the value range set via the filter. Therefore, users should not be able to save slicer/filter settings.
