Here’s how to do it:
- Let's start by opening the 'Visualizations' pane on the right side of your Power BI workspace.
- Look for the 'Slicer' visualization icon and click it to add a new slicer to your report.
- Drag your Date field from the Fields list into this slicer. Power BI will automatically recognize it as a time field.
- With the slicer selected, click the 'Format' icon (the paint roller) to access visual customization options.
- In the Format pane, find and expand the 'Slicer settings' section where we'll transform this into a timeline.
- Under the slicer type options, click the dropdown and select 'Timeline' instead of the default 'Dropdown' option.
- That's it! You now have an interactive timeline in your Power BI report. You can adjust the date range by dragging the sliders or selecting specific time periods.