Forum Discussion
Post ProdigyDate range slicer (or other data range user interface) to be updated automatically
Most Valuable ProfessionalHi JustinDoh1,
have you enabled the following option?
"Don't allow end user to save filters on this report."
Post Prodigymwegener 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.
- mwegener
- JustinDoh1
mwegener Thank you so much for your feedback. I am learning new here. Unfortunately, by having "Filter on this page", available data to show is all limited to last 14 days, and it appears that date slicer would not move farther to the left (graph would not show prior to 14 days). My requirement is that the graph should not be limited to the date range slicer (which I have 14 prior days from today), but it can go older date. Here are what I am trying to accomplish: After daily data refresh, (#1) Graph should reflect last 14 days, (#2) date range slicer should dynamically adjust to last 14 days & (#3) user can enter different date prior to 14 days into the slicer and graph should be reflected accordingly. I am sorry for asking too much. I am just trying to see if it would work or not with what PowerBI can offer or whether any custom coding is required to meet these three requirements. Thank you!