Between date slicer is not updating automatically with the max date

[araoim]

Hi,

I have 2 pbix files that are publised in the same workspace.
- data file is where I'm importing data using import mode from a SQL server and create a PBI model
- report file that connects to the data file via Direct Query and in this file I'm creating the visuals.
In the report file, I created a date between slicer( the source for this is a date from a calendar table) but first time when I developted the report on Power BI desktop the slicer automatically was showing the min and max date from my fact table. I published the report to the service and next day when I opend the report the slicer was not showing the max date, was having the selection from my previous day. I had to drag manually the slicer to see the max date.
I went to Power BI desktop opend the report file, refresh it and the same behaviour, I see only the selection from my previous day. If I'm dragging manually the slider I see all the dates.
I changed the source of that slicer with the date field from my fact table, updated the slicer with max date and published again the report. The next day the same behaviour, the slicer was showing me the selection from when I published the report, and not the max date. I have to dag manually the slider to see the max date.

I want to say that I'm using the latest version of Power  BI desktop and this is a new report, is not an old report that worked before and now is not working  anymore. The same issue I'm having in all PBI reports that are using between date slicer.

Does someone have a solution or an idea how to fix this?

[Anonymous]

Hi  @araoim ,

I wasn't able to reproduce your problem. I wonder if  there's a problem with my reproduction steps, can you provide a sample pbix or a detailed reproduction step? (Please be careful not to include sensitive information)

Best regards.
Community Support Team_ Caitlyn

[araoim]

Hi,

Here is a sample data
Pbix samples .
I managed to replicate only one scenario with test data, the one when I'm using the date from the fact table as a source for my date slicer. But this issue happens with my reports also in other scenarios, like when the source for date slicer is from a date table. Looks like is ramdom, sometimes the slicer is refreshing and sometimes is not.

Regards,

Mioara

[araoim]

Redarding the issue for between date slicer which is not updating automatically with the max date, I found a solution in an online tutorial. 
When you create a beween date slicer in Power BI desktop, in order for it to update automatically with the last refresh dates, you need not to test it on desktop. To see if is working formatt it in desktop and publish the report on service and test the slicer there. If you test it on desktop, and you select certain values, Power BI by default is hard coding those values and even if at the end you select all possible values, Power BI will save those values from Desktop and after you publish the report and deploy it to production, always the report will show the last data that were selected on desktop before publishing the report.

Because of this behaviour we need to be carrefull when we updating the report in the future, with new functionalities, not to touch the slicer or it will brake and on service will show automatically the last values tested on development environment. If we touch it durring developments, then on service, always users need to drag the slider to see the latest data.