How to Filter by Week in Power BI

Quick summary

Filtering by week in Power BI requires creating a Week Number column using a DAX formula and adding it to a slicer. Once configured, users can instantly filter any report visual by selecting a specific week number from the slicer panel.

Steps

1. Click on your visual to select it as the starting point for adding a week filter.
2. Go to Modeling in the ribbon to access data modeling options.
3. Click New Column to begin creating a calculated column.
4. Use a DAX formula to create a Week Number column based on your date column.
5. Click the check icon to commit and apply the DAX formula.
6. Review the result — the formula generates a column with week numbers derived from your Date column.
7. Drag the Week Number column into the slicer to enable filtering data by selecting a specific week.