Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

How to make Visual graph follows the date range filter automatically (after daily data refresh)

I am sharing my Pbix file here at Google drive.   Thank you so much for those of you who tried to help me for last three weeks, but my issue has not been resolved.  So, I am posting again (this ti...
Need Help
  • JustinDoh1's avatar
    JustinDoh1
    5 years ago

    vanessafvg 

    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!

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

can't you apply the same relative date filter to the date field in the graph visual itself?

or alternatively, use a measure which filters the values for the last 14 days in the table. whatever you try, you should absolutely follow vanessafvg  advice and work with a date table. It's highly recommended and a "best practice"