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.

Anonymous's avatar
Anonymous
Not applicable
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.