To add a date filter in Power BI, you can follow these steps:
- Open your Power BI report or dashboard in Power BI Desktop.
- In the “Fields” pane on the right, find the date column you want to use for filtering.
- Drag and drop the date column field into the “Visualizations” pane.
- Choose the visualization type you want (e.g., line chart, bar chart, etc.) and customize it according to your data.
- In the “Visualizations” pane, click on the “Filter” icon (looks like a funnel) to open the filtering options.
- Under the “Filter” section, find the date column you added and click on the “+ Add filter” button to create a new filter.
- Choose the type of filter you want to apply, such as “Between”, “Before”, “After”, etc.
- Specify the date range or criteria for the filter.
- Click “Apply filter” to see the filtered data in your visualization.
Example:
If you have a sales dataset with a “Date” column, you can add a date filter to see the sales data for a specific month. After following the steps above, you can set the filter to “Between” and specify the start and end dates of the month you want to filter. This will show you the sales data only for that specific month.
Remember to save your Power BI report or dashboard after applying the date filter.