Forum Discussion
Solved
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. ...
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])))Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
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].
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.