Forum Discussion

Companyuser101's avatar
Companyuser101
Icon for Helper II rankHelper II
3 years ago
Solved

Wrong Date from reset

Hello,    I have this date slicer:   Here I can select dates from the past and the present.    I created the date table like this: Date_Dealer_Inventory = CALENDAR(DATE(2022,5,21),TODAY...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    3 years ago

    you can't.  The meta data is hard coded based on your last modification/upload.

     

    One way to work around that is to use a selection slicer  with textual representation of your dates, but that  requires daily refreshes of the dataset.

     

    - create a string representation of your date column, replace the latest date with a string "Latest"
    - sort that new column by the original date column
    - add a slicer or visual/page/report level filter
    - set the filter to "Latest"
    - publish the pbix to the workspace/app

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

you can't.  The meta data is hard coded based on your last modification/upload.

 

One way to work around that is to use a selection slicer  with textual representation of your dates, but that  requires daily refreshes of the dataset.

 

- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app