Forum Discussion
Date Slicer
Hi Team
Does anyone know how to create a slicer like the screenshot below?
Any suggestions are appreciated.
Cheers
Zach
Steps to Set a Relative Date Slicer:
1. Add a Slicer Visual:
From the Visualizations pane, add a Slicer to your report.
2. Drag a Date Field:
Drag a date field (like OrderDate, TransactionDate, etc.) into the slicer.
3. Change to Relative Mode:
Click the drop-down arrow on the slicer (top-right corner).
Choose Relative from the slicer options.
4. Set the Relative Period:
You can now specify:
Time Unit: Days, Weeks, Months, or Years.
Value: e.g., last 3 months, last 7 days, etc.
Direction: In the last / Next / This.
Follow the below article:
https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
2 Replies
Steps to Set a Relative Date Slicer:
1. Add a Slicer Visual:
From the Visualizations pane, add a Slicer to your report.
2. Drag a Date Field:
Drag a date field (like OrderDate, TransactionDate, etc.) into the slicer.
3. Change to Relative Mode:
Click the drop-down arrow on the slicer (top-right corner).
Choose Relative from the slicer options.
4. Set the Relative Period:
You can now specify:
Time Unit: Days, Weeks, Months, or Years.
Value: e.g., last 3 months, last 7 days, etc.
Direction: In the last / Next / This.
Follow the below article:
https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Perfect thank you!
