Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Sarany03
Frequent Visitor

Between date slicer issue

Hi Team,

The between-date slicer is not updating the dates. I have data until February 19, but it only shows the end date as February 17 when published. I need it to display the latest available date in the between-date slicer

Sarany03_0-1740046614144.png

 

Sarany03_2-1740046694773.png

 

 

2 REPLIES 2
Anonymous
Not applicable

Hi, @Sarany03 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

 

Best Regards

Yongkang Hua

govind_021
Super User
Super User

 

1. Data Refresh Issue
Issue: The report might not be refreshing properly, causing outdated data to display.
Solution: Ensure the dataset is refreshed in Power BI Desktop and Power BI Service, and manually refresh it.

2. Cache or Browser Issue
Issue: Cached data in Power BI Service or browser may be delaying slicer updates.
Solution: Clear the cache, refresh the page (Ctrl + F5), or use an incognito window.

3. Date Column Data Type
Issue: The date column might not be recognized as a proper Date type.
Solution: Ensure the column format is set to "Date" instead of "Text" or "DateTime."

4. Slicer Default Selection
Issue: The slicer might be set to a fixed default selection instead of updating dynamically.
Solution: Manually adjust the slicer and consider creating a dynamic "Latest Date" measure.

5. Data Model Relationship Issue
Issue: The date slicer might be filtering based on a disconnected table.
Solution: Verify that the slicer is using a correctly related date column from the fact table.

6. Publishing Delay
Issue: Power BI Service may take time to reflect changes from Power BI Desktop.
Solution: After publishing, manually refresh the dataset and check for refresh failures.

7. Slicer Based on a Different Table
Issue: The slicer might be using a date table that lacks the latest date.
Solution: Ensure the slicer uses the correct date column from the fact table or a common date table.

8. Auto Date/Time Feature Interfering
Issue: Power BI’s "Auto Date/Time" feature may be generating hidden tables that interfere.
Solution: Disable "Auto Date/Time" under File → Options → Global → Data Load.

9. Filters Applied
Issue: Other filters in the report might be restricting the slicer’s date range.
Solution: Check and remove any unnecessary filters on visuals, slicers, or at the report level.

10. Timezone Differences
Issue: Data refreshed in a different timezone may cause date misalignment.
Solution: Adjust timezone settings in the data source or Power BI transformations.


Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.