Forum Discussion
Create Dynamic Date range Slicer that changes to new date based on data
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.
Hi Anonymous
Daft question but if the refresh working in the browser, are you getting the data pulled through?
When testing this in the desktop when I call a refresh it does appear to be working.
If it is pulling through the data correctly the next thing I would check is that you have Persistent filters turned off:
This saves the last filters applied to a report.
If it is neither of these let me know!
Thank you for the response. In the the browser, each refresh brings in new data. If the report was published on 1st August, 2024 the report will carry this date as default even when there will be new data for 2nd August and no filters applied. The max date in the date range will still be showing 1st August even if you clear filters or turn off saving filters. Until you change the maximum date manually on the report before you can see data for 2nd August. If you publish same report again it continues to retain the date without automatically adjusting to show the new date.
I want the Year slicer to still remain a dropdown and show past years but anytime a year is switched, the date should automatically change to show the dates corresponding the the date available for the selected year in the fact table. This used to happen automatically when you publish the report without clicking on the date slicer to default to a particular date.
Does this provide any insight to the issue?