# How to Filter by Week in Power BI

> To filter by week in Power BI, select your visual, go to Modeling in the ribbon, and click New Column. Enter the DAX formula for the Week Number column, and click the check icon to commit. Finally, drag the Week Number column into a slicer to filter your data.

Canonical: https://livedemo.ai/tutorials/how-to-filter-by-week-in-power-bi/
Apps: Power BI
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3deeab56e05a00fe5aa6/preview?step=1

## Steps

1. Click on your visual.
2. Go to 'Modeling' in the ribbon.
3. Click 'New Column'.
4. Use the following DAX formula to create a 'Week Number' column.
5. Click the check icon to commit and apply the formula.
6. This formula will create a column with week numbers based on the 'Date column' in your dataset.
7. Drag the 'Week Number' column into the slicer. Now, you can filter data by selecting a specific week.