Forum Discussion

vvangur's avatar
vvangur
New Member
5 years ago
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.  ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.