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.

Rupak_bi's avatar
Rupak_bi
Icon for Super User rankSuper User
1 year ago

Hi Anonymous ,

 

Inside Slicer its not possible (to the best of my knowledge). But there is an alternet way to achive this.
1. Create a measure like below and use that measure to filter your report. 
Max_Date = selectetvalue(table[date]),max(table[date]))
2. keep the slicer sepatate with the same date column.
by this way the measure will select the max date if nothing is selected in the slicer, else it will select the slicer date.