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.

kpost's avatar
kpost
Icon for Solution Sage rankSolution Sage
1 year ago

Thank you for this insightful post.  I have noticed that some of my pages automatically refresh to the latest dates and some of them do not, and I could never figure out why!  Thank you for solving this mystery for so many people experiencing this issue.

Lesposto's avatar
Lesposto
Frequent Visitor
1 year ago

You are welcome! Anyway doing this we can solve the problem for the MAX date, which will automatically update to the latest date in the DB, but we still experience problems with the MIN date, which can't be set by default. I mean, if you have 3 years of data and you create a date slicer, it will select 3 years of data, which could be expensive.

 

It would be great to have the possibility to set a default value for both MIN and MAX date of the slicer, so that the report can always open in a predetermined range. I found many ideas in the "Ideas" section, but none of them have enough votes. Maybe merging some of them could improve our chances to be heard by Microsoft, but there are many of them.