Adnan C on 30 Aug 2020 15:28:20
The ability to set the Slicer Date Range Anchor date using a DAX expression, similar to the ability to set Title text for text boxes.
This will allow the report author to set the default value dynamically, e.g.,
1. based on an offset from the current system date, or
2. based on a function of a column provided in the data model, e.g., last calculated date, last updated date, last loaded date, etc.
- Comments (2)
RE: Slicer Date Range Anchor Date: Ability to set using an expression
Absolutely agree, it looks as some unifinished work of an Power BI developer. Fixed anchor date in relative date slicer is absolutely nonsense.I create new Idea with this and one more issue in relative date slicer, please vote also here:https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=9578f230-ef1b-ee11-a81c-000d3a0ec312
RE: Slicer Date Range Anchor Date: Ability to set using an expression
You may create your custom date range slicer using method mentioned at https://www.linkedin.com/pulse/custom-range-date-slicer-power-bi-dynamic-defaults-more-a%25C5%259F%25C4%25B1ro%25C4%259Flu/?trackingId=VZ5gCWtsTBiaS460f3oTkg%3D%3D