Skip to main content

    Power BI

    Needs Votes

    Anchor date for relative slicer changed by report user

    Vote (21) Share
    's profile image

    on 11 Jan 2018 22:38:18

    Now only author of report can set and change anchor date for relative slicer. It would be great if also consumer of report could change that date while using the report.

    Comments (2)
    's profile image Profile Picture

    Josef Jurák on 07 Jul 2023 07:24:46

    RE: Anchor date for relative slicer changed by report user

    Yes, fixed anchor date, breaks relative filter, because is not relative but fixed. For proper work must be dynamiclly set during report view time.But more usable will be to set as calculated value (fx), this allow set business required date automaticaly, or also manualy thru another slicer or what-if parametr.Please vote here:https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=9578f230-ef1b-ee11-a81c-000d3a0ec312

    's profile image Profile Picture

    Jon on 06 Jul 2020 00:13:26

    RE: Anchor date for relative slicer changed by report user

    This is so necessary, got rid of relative date slicers as report users wanted to define custom time periods.