This interactive demo was created free with Storylane in 2 minutes. Create your own demo
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:
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.
