Forum Discussion
Create Dynamic Date range Slicer that changes to new date based on data
I have a Date range Slicer that works with the date field in the DateTable. The date on the slicer does not update to reflect new data after the report has been published. Every time we refresh the report, I want to see the dates in the slicer updated according to dataset not defaulting to the date it had as at when the report was published.
I have checked all the forums to see which method is working but I only come across articles pointing to steps that does not produce the result I am looking for.
This was the last known method I used Set a Dynamic/Default/Changing Date in Power BI Date Slicer - YouTube Rush published this video about a year ago. The steps does not work any more on the current power bi report.
Hi Anonymous The steps I followed and which worked for me is, I readded a Academic Year slicer and Date Slicer in report. According to the requirement, I wanted to remove interaction on 'Academic Year' slicer and something unusual is, the date slicer lost it's interaction with all other visuals automatically. I retested it again and it is same. So, basically the fix is to remove the blocked interaction on Date Slicer. I am not sure if this problem is with recent version of PBI.
11 Replies
I would suggest you to have a today as slicer option, so that whenever it is refreshed, it points to the most recent date.
https://www.youtube.com/watch?v=pt7dI8af_m8
Anonymous
Hi Anonymous
I assume you are meaning a single select slicer that isn't updating? This is an issue I have encountered before.
My work around is to use the Filter pane to apply a Top 30 filter based on the date itself.Here for example it always shows the last 30 dates worth of data:
I have tested it on a double select slider and it appeared to work also.
If this helps please mark it as a solution for others to find 🙂
SamWiseOwl Thank you for your response. This is how the slicer looks like
The Date range should update to only the days transaction happened in the year. That is the minimum date will show the first date while the maximum date will update to show the last date that is available in the data. For the current year the maximum date will continously change as new data becomes available even after report has been published.
Unfortunately the Filter option does not fit this solution. Thank you so much for your contribution.Hi Anonymous
Apologise I must be misunderstanding, this is what I have done.
Set the Year dropdown slicer to Top 1 by Max Calendar Year this will change whenever the calendar table is refreshed by new data.Under Format make sure the drop down slicer can FILTER the Date slicer using interactions.
Here I have added a new date into my model which regenerates the Calendar table which causes the dropdown to change updating the Date slicer:
Hi all,
I am looking for a similar solution where the Date range (with between) changes or picks up the max date with selection from Academic year slicer. As in my semantic model, for Academic Year 2021/22 ,max date is 28/08/24 and similarly for 2022/23 , max date is 27/08/24 and so on.
Any help is appreciated!Hi Anonymous The steps I followed and which worked for me is, I readded a Academic Year slicer and Date Slicer in report. According to the requirement, I wanted to remove interaction on 'Academic Year' slicer and something unusual is, the date slicer lost it's interaction with all other visuals automatically. I retested it again and it is same. So, basically the fix is to remove the blocked interaction on Date Slicer. I am not sure if this problem is with recent version of PBI.
raji_n Thank you for your response. What I am looking to get is slightly different. I am using a Date range that has a minimum and maximum (between). both values are suppose to update based on the available dates in the data not necessarily pointing to today if there is no record for today.
