Forum Discussion
Post ProdigyHow to make Visual graph follows the date range filter automatically (after daily data refresh)
Thanks for help.
Date Slicer gets updated by ifself (before daily data refresh and after daily data refresh) for relative last 14 days, so I don't think I have an issue with a date slicer.
The issue is I want visual to go along with the date ranges (relative: last 14 days). But apparently, it show the whole range of dates (not last 14 days).
I went ahead and created a date table (that ranges from last 14 days to yesterday), and linked to a main table. It appears to be working fine. I publshed in DEV and will take a look tomorrow after daily data refresh. I think it will work. 🙂 Thanks!
Post Prodigyvanessafvg Thank you for your help. Yes, it is supposed to be updated everyday. Sorry. What is the logic of creating a continous set of dates? It is new to me.
Community Championok, if your dates aren't continious and you dont have a date table to regulate that it has all date values, then there could be issues with using time and date functions- its best practise to always create a date table and link your dates to that, that will eliminate if that is the issue.
So what you basically saying, is that your current14 day selection works fine the first time (the one you have in the pbix), but when you refresh the data it shows all the data for the current calendar year?
Its hard to know what happens after you refresh, can you send an example of what it looks like its refreshed. Have you tried placing the relative filter on the line chart itself?
You can also create a date table with just the dates you want in it dynamically and link that table to your data and plot that date from the date table on your visual.
I dont know the exact solution to your problem but I think the date table with only the dates you need, even if not elegant will probably work.
- JustinDoh1
Thanks for help.
Date Slicer gets updated by ifself (before daily data refresh and after daily data refresh) for relative last 14 days, so I don't think I have an issue with a date slicer.
The issue is I want visual to go along with the date ranges (relative: last 14 days). But apparently, it show the whole range of dates (not last 14 days).
I went ahead and created a date table (that ranges from last 14 days to yesterday), and linked to a main table. It appears to be working fine. I publshed in DEV and will take a look tomorrow after daily data refresh. I think it will work. 🙂 Thanks!