Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

auto select max date from slicer

Is there a way to default a date slicer in a report to select the max date?  I have a report that I am presenting with a source from SQL.  I want the report to auto select the max or most recent snap...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the replies from johnt75. Attaluri and Rupak_bi.

     

    Hi Anonymous ,

     

    You can use preselected slicer to achieve this effect:

    I create simple test data:

    Create a measure:

    Pre selection = 
VAR _select=SELECTEDVALUE('Table'[Date])
RETURN
_select=TODAY()

     

    Create a calculated table:

    _PreselectedSlicer = DATATABLE("IsDirty", BOOLEAN ,{{False()},{True()}})

     

    Result:

     

    Best Regards,
    Zhu

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

Attaluri's avatar
Attaluri
Frequent Visitor
1 year ago

You can create a flag column in date table. It will show "Latest Date" for current date and for rest of the rows it just shows the dates. You can use this column as slicer and fillter on latest Date. Using this approach every time you open the report you see latest date selected in report.