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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vvangur
New Member

In between date slicer should set to refresh date

Hello,

 

I have between date slicer where I can select 'start date' and 'end date'. But the user want to see the end date should be change to max date dynamically whenever the data get refreshed. 

 

Can anyone help me on this?

 

Thanks

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@vvangur 

You can not make slicer to have default slicer. Instead, if the user wants to have the value between the start date to max date, you can create a measure to achieve this.

 

1. Create a distinct table:

Table 2 = DISTINCT('Table'[Date])
2. Create a measure:
Measure = CALCULATE(SUM([Value]),FILTER('Table',[Date]>SELECTEDVALUE('Table 2'[Date])))

 

Vpazhenmsft_0-1625538216402.png

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
sohananahid
Post Partisan
Post Partisan

I also having similar issue. I have in between Date slicer using "Date" col from  "Date Table". 

Date Table = CALENDAR(min('Procedure Content'[Content Created Datetime]), TODAY()). 
When latest "Refresh" date is 9/14/2023 [which is today], the Date slicer right most edge points to the date the Power BI report was published [8/18/2023].
sohananahid_0-1694705454382.png

The user of the Report wants the slicer 's right edge adjust automatically to the latest Refresh date, hence to 9/14/2023 as of today. Any suggestion? Many thanks.

V-pazhen-msft
Community Support
Community Support

@vvangur 

You can not make slicer to have default slicer. Instead, if the user wants to have the value between the start date to max date, you can create a measure to achieve this.

 

1. Create a distinct table:

Table 2 = DISTINCT('Table'[Date])
2. Create a measure:
Measure = CALCULATE(SUM([Value]),FILTER('Table',[Date]>SELECTEDVALUE('Table 2'[Date])))

 

Vpazhenmsft_0-1625538216402.png

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Not really sure what you are looking for, can you give some more examples. If I understand correctly the end date in your slicer should only show the max date of your particular table, right? So if you have the slicer connected to that table, it will only show the min and max dates of the Date column in that table anyways. If you have added a Calender Table for example, then you might only get the min and max of that table. If that's the case I would suggest to relate both of them, and use the source table in your slicer. That source table is then linked to your Calendar Table, so you can use it in other visuals and/or tables as well.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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