Forum Discussion
cyclist007
Responsive Resident
7 years agoDate Filter - Range AND Relative in same slicer/filter
The current date filter in Power Bi lets you either select a range of dates OR a relative date range with respect to an Anchor date. Our requirements need the date filter to allow select a date r...
cyclist007
Responsive Resident
7 years agoHere is an example:
Generally a user wants to see analyse Sales data for say last 1 week/month, etc.
But there are certain cases where users would want to see Sales for say 1 week/month before July 4th ... right now the user would have to be given the default filter where start date and end date has to be selected.
But just like the developer can set an anchor date, is it possible to have adate filter in which the end-user can also select the anchor date or can the anchor date become a dynamic field (such that it can be derived from another input/calculated field)?
v-yuta-msft
Community Support
7 years agoHi cyclist007,
What does anchor date mean? Could you share some sample data?
Regards,
Jimmy Tao
- cyclist0077 years ago
Responsive Resident