How to Filter by Week in Power BI

George Apostolov
Updated 05 Oct 2026
- ▣ Power BI

This guide is an interactive LiveDemo. Create interactive demos of your own product: Interactive demo software · Interactive customer onboarding guides · Start free

How to Filter by Week in Power BI: step-by-step guide

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

Quick answer: 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.

About this Power BI tutorial

Filter your Power BI data by specific weeks easily. Create a custom week number column using DAX and add it to a slicer for quick reporting. This guide shows how to filter by Week in Power BI in 7 steps, starting with "Click on your visual" and finishing with "Drag the 'Week Number' column into the slicer. Now, you can filter data by selecting a...". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.