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())

 

So the last date which can be selected is todays date.

 

But when I click on the reset symbol for the power BI reports it always goes back to an date in the past. Its the date on which I uploaded the power BI report. I uploaded the report on the 30.05.2023

 

How can I fix the date slicer, so it always shows todays date when I click on the reset button?

 

Thanks in advance!

 

 

 

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

1 Reply

  • 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