Date Slicer - End Date not showing most recent dates

[JimJim]

Hi,

Please see the following slicer on one of my reports, a user can input only a Start Date. 

The problem I have is that the End Date shows '23/03/2020' and not '25/03/2020' which is the most recent date on the report. As you can see, the End Date is inactive and the report shows data for both 24/03/2020 and 25/03/2020. My only concern is that it may be confusing for end users.

I would like the End Date on the slicer to show 25/03/2020 or even hiding it completely would be fine. Any suggestions?

[amitchandak]

Can you check the max date of the table column (Actual start date) from which it is coming?  Seem like ending at Max date

Ideally, we create a date calendar and use it. We stop date calendar at today

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

[JimJim · Accepted solution]

 Guys, I'm an idiot. I was using the week commencing date in the slicer instead of the date, so it will always show the previous Monday. Apologies, I was too quick to jump in with a question.

Thank you for taking the time to reply

[amitchandak]

@JimJim , No problem. It happens. Please mark the solution.