How to Filter by Week in Power BI
- George Apostolov
- 05 Sep 2025
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.
Create your first interactive demo in minutes
No credit card required • Start building today
