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