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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Negi
Frequent Visitor

Date Between Slicer not showing latest end date from Report.

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 ?

1 ACCEPTED SOLUTION
v-yohua-msft
Community Support
Community Support

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

vyohuamsft_0-1713752611234.png

 

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.

View solution in original post

5 REPLIES 5
v-yohua-msft
Community Support
Community Support

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

vyohuamsft_0-1713752611234.png

 

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
Impactful Individual
Impactful Individual

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
Resident Rockstar
Resident Rockstar

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


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

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
Resident Rockstar
Resident Rockstar

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)

AmiraBedh_0-1711979061157.png

 

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.