Forum Discussion

Oliya's avatar
Oliya
Frequent Visitor
3 years ago

Dynamic selection in slicer data table

Can I automatically select a value in the date slicer. If the data is for eg. till march 2022 then by default all the date should be selected till march 2022 and it will change based on the latest month.

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    - create a string representation of your date column, replace the latest date with a string "Latest"
    - sort that new column by the original date column
    - add a slicer or visual/page/report level filter
    - set the filter to "Latest"
    - publish the pbix to the workspace/app