Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

igoalZero

Issues with Date slider not sliding to recent date

Submitted by on ‎02-16-2023 09:45 PM
I'm using a slider for Dates like in this picture.
igoalZero_1-1676612508211.png

I have a datasource with values for a lot of elements and the slicer is used to filter the dates to analyze. The problem is when  I publish the report (and configure the gateway in order to be refreshed every day) the last day of the slicer doesn't update to the last day in the database.

 

For example, Today I have values in the database and the last day in the database is 15th of January and slicer is set to 15th of January.

I publish the report and  set a schedule refresh. The problem will be tomorrow when the report will be refreshed that the last day in the dataset will change to maybe 16th of january and the slicer will be the same 15th of january instead of the  16th of january .
Status: Needs Info
See more ideas labeled with:
8 Comments (8 New)
Comments
igoalZero
New Member
‎02-16-2023 09:46 PM

Please note : I am using Odata as the datasource

 

Anonymous
Not applicable
‎02-19-2023 06:23 PM

Hi @igoalZero 

If you refresh the date in Desktop , the date is same as the date in data source , right ? Did you set date filters in Service ?

 

Best Regards,
Community Support Team _ Ailsa Tao

Clinical_Epi
Advocate III
Advocate III
‎05-16-2023 11:33 PM

The same thing is happenign with all of my dashboards, which are using a dynamic date table that is related to a date column in the data set(s). Also in one report I'm using the date from the source data, which updates every day (Hospital data), but alas my date slider still only has the date slider still set as the date when it was last uploaded by me.

The underlying data refreshes in the dashboard, but I have to drage the slider to the far right - then I see my graphs/tables update with the latest day worth of data.... 

This is very frustrating as I've been working the same way for 3 years, my dashboards work fine on the old 'on-prem' version of Power BI.

 

But, when I update the data using our Denondo connector to our Enterprise space in https://app.powerbi.com/  making sure field names and column formatting is all fine, everything looks the same, filters the same etc.. however the date slider fails to update to the new date each day...

 

Im using March 2023 desktop software and we have enterprize licencing to connect to Azure via Denodo. 🙂

 

Why is the date not refreshing do we think?

(there are no date filters at page level - nor applied to the slider...)

Clinical_Epi
Advocate III
Advocate III
‎05-17-2023 10:39 PM

So here is an example below - you can see it was updated by the system today using the Azure data for it, you may notice a little space to the right of the slider...

Clinical_Epi_0-1684378348643.png

Here is how it looks now I've expanded the date - this is a major issue btw!

Clinical_Epi_1-1684378483440.png

You will notice the end date is yesterday - this is the latest date in the table I pull from, it updates hourly... in my dev area the dashboard functions exactly the same way - but with a daily update only... still the slider issue remains!

 

 

amiris
New Member
‎07-17-2023 07:45 AM

Hi all,

 

I'm late to the party, but has anyone found a solution for this issue?

 

I have a date slider that is from a DAX calendar table (connected to the data) that used to update to the most recent date and no longer does so - and nothing has touched the filters or the dates otherwise to cause this. The new data is there when it updates every week, as is the new date, but I have to go in and move the slider to the far right manually now to display them, when it used to do so automatically when the data refreshed. Would greatly appreciate any tips to get it working again!

DanielKres
New Member
‎09-21-2023 09:04 AM

We're having the same problem.  Date sliders don't appear to have a cleared state, therefore when the data updates, the slides continues to filter the data using old dates.  This is a MAJOR which effectively prevents us from using date sliders because it would force the users to "drag to the right" every time they open the dashboard in order to see recent data.  This seems like an obvious thing!  Are there any solutions being worked on?

akokorin
New Member
‎12-11-2023 05:59 AM

Try using "after" slicer style:

akokorin_0-1702303141686.png

 

sandermatthijs
Advocate I
Advocate I
‎08-23-2024 12:35 AM

To help folks coming here directly: this issue has both a fix and a 'work-around' I think, as listed in below links. 

Fix: use Relative date filters to set date on filter to "today". Or place filter and DON"T TOUCH IT before publish. 

 

Solved: Date slicer slider end date to be today - Microsoft Fabric Community

Workaround: 

Solved: Date Between slicer won't update end date to today... - Microsoft Fabric Community

Idea Statuses