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.
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.