Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamically latest date selection in power bi single select slicer

My req is when report will be opened in power bi services, by default latest date will be selected in a single select slicer. Consider in import mode there are 10 dates are coming nd assigned to a slicer(single select dropdown).By default it shows older date as selected date.I need to do opposite, it should be latest date selected by default and if user want to select other dates they can change manually.My landing page by default should show latest date dynamically. I have checked Power BI community and Stack overflow fully for this issue but it does not get resolved.

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • nandukrishnavs's avatar
    nandukrishnavs
    Community Champion
    6 years ago

    Anonymous 

     

    I'm not sure whether the below solution will help you.

     

    Create a calculated column.

    Filter Column = IF(MAX('Table'[Date])=[Date],"Latest",FORMAT([Date],"dd-mm-yyyy"))

     

    Then use this column in the slicer.