Date Between Slicer not showing latest end date from Report.

[Negi]

Hi All,

I have created the 2 Power BI report which is connected to Azure Synapse and refresing on daily basis. After that I have added both the report to App . I am using Date between slicer in the report. I want this slicer should show dates as per from 1-jan-24

Now the issue is that after publishing the report in app its showing same start and end date when those report published. even if other user using reset filter option in App its changed to date range on which I have published the report. 

and every time users needs to manually change the end date. 

Can any body suggest me how to solve this issues. using date between slicer ?

[v-yohua-msft · Accepted solution]

HI, @Negi 

Perhaps you can click on Clear Selections in Power BI Desktop and then Publish to service so that you don't have to manually adjust the end date

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnalyticPulse]

are you manually changing the date when developing the report to check the functionality of the slicer?
i would suggest once you configure the slicer according to your measure dont disturb it manually in powerbi sesktop app first publish it and then change the date and see if your report slicer is working of not. it happened with me once when dates were not changing according to measure because i had changed the dates manually. it was suppose to show the 6 months back date and current date/latest date from data. i had to reconfigure the  date slicer.

If this helped, Follow this blog for more insightful information about data analytics
https://analyticpulse.blogspot.com/
Please Subscribe AnalyticPulse on YouTube for future updates:

https://analyticpulse.blogspot.com/2024/03/superstore-sales-2022-vs-2023-year-on.html
https://www.youtube.com/@AnalyticPulse
Please subscribe CogniJourney On Youtube For Daily fun facts:
https://www.youtube.com/@CogniJourney

[AmiraBedh]

Can you provide an example of what you need to see depending on the period when you publish the report?

[Negi]

Hi @AM ,

My Report contains last first year data and by default when I created this report I want to be published for current year only .For example I published the report on 27 Mar 31. where in Power BI desktop my slicer date selection was 1-jan-24 to 27 mar 31. and 27th mar 31 selected because max date in the data set was 27th only. 

So now whenever any user viewing this report they see only 1-jan-27 mar 31 data by default and everytime they need to change the date from date slicer. even if they are using reset filter option its showing default filter of 1-jan-24 to 27 mar 24 only.

Previously we were using Tableau and recently migrated to Power BI and this issue looks very stange.  

[AmiraBedh]

In this case it can be related to your model.

Imagine I have a Sales table with a SalesDate column linked to a calendar table.

I want to see the sales by default from the 1st of Jan 2024 until the 31st of March 2024.

How to proceed?

You can do it manually using this slicer https://appsource.microsoft.com/en-us/product/power-bi-visuals/truvizinc1674781244292.date-picker-by...

Or dynamically by adding another calculated table as a calendar where it starts with the 1st date of the current year until today (I suppose you have a daily refresh)

CalendarTable = 
VAR CurrentYearStartDate = DATE(YEAR(TODAY()), 1, 1)
VAR TodayDate = TODAY()
RETURN
    CALENDAR(CurrentYearStartDate, TodayDate)