Forum Discussion

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

Graph does get adjusted automatically to the Date Slicer

I am sharing my Pbix file here.   I have posted my issues several times, but has not gotten the solutions yet.   This is requirement: Graph should reflect to the date range of the Date table. C...
Need Help
JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
5 years ago

lbendlin Thank you for your help. I am trying to understand what you indicated. When you refer to 'daily refresh process', are you referring to somewhere in Settings at Dataset(s)? Or are you referring to modificaiton in Pbix file? Also, I realized that Date Slicer does not get updated to the date ranges that I created using a separate "Date" table (which populates date as "calendar ( today()-16, today()-1)" after daily data refresh. So, there is one more issue to my initial post. Thanks.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

"I created using a separate "Date" table (which populates date as "calendar ( today()-16, today()-1)" after daily data refresh"

 

I would recommend against that. You want a Dates table that is marked as such, and you may want to consider a fixed table that comfortably covers your data date range - in case you want to apply time intelligence functions later.