How to Filter by Week in Power BI

‍

‍

If your data doesn't already have a week number, you can easily create one using DAX (Data Analysis Expressions). This is useful for filtering data by week. Here’s how to do it:

‍

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.