Forum Discussion

ChadPortman's avatar
ChadPortman
Frequent Visitor
5 years ago
Solved

Anchor date on Slicer

I have a date slicer in my report that will allow the user to select any date or date range they want to view. However I want the default view to always be the most recent date only. The data gets up...
slicers
  • Icey's avatar
    Icey
    5 years ago

    Hi ChadPortman ,

     

    It is not supported in Power BI. When you select a single date value in your slicer and dataset is refreshed, the selected value won't change to the latest one automatically. It is needed to use Relative Date slicer. But it doesn't meet your requirements. 

     

    Then, one workaround, create a column like below and use this column as the slicer, set the default value as "yesterday".

    Modified Date = IF( 'Your Table'[Date] = MAX( 'Your Table'[Date] ), "yesterday", 'Your Table'[Date] )

     

     

    Best Regards,

    Icey

     

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

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi ChadPortman ,

 

It is not supported in Power BI. When you select a single date value in your slicer and dataset is refreshed, the selected value won't change to the latest one automatically. It is needed to use Relative Date slicer. But it doesn't meet your requirements. 

 

Then, one workaround, create a column like below and use this column as the slicer, set the default value as "yesterday".

Modified Date = IF( 'Your Table'[Date] = MAX( 'Your Table'[Date] ), "yesterday", 'Your Table'[Date] )

 

 

Best Regards,

Icey

 

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