Forum Discussion
Date Filter Scenario
Hi All,
Need your help on solving below scenario
I have a column "Order Date" which i need to use as a filter.
and same "Order Date" is shown in X axis and "Sales" in Y axis
I should able to select as Year,Quarter,Month,Week in the filter and
when i select Year filter, it should show me current year+last 4 years in X axis
when i select Month filter, it should show me current month+last 4 months in X axis. similarly for weeks and quarter.
X axis values should change dynamically as we change the filter.
Thanks,
Rajesh
1 Reply
- v-yuta-msftCommunity Support
Anonymous ,
I'm afraid slicer couldn't achieve your requirement. I would suggest you to use bookmarks instead.
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.