Display all weeks for full month based on selected week

[joshua1990]

Hi all!

I have a simple report with a year-week slicer on top.

Here I always filter for an individual week.

Then I have a matrix that shows me the values for the selected week.

Now I would like to display all weeks for the month based on the selected week.

For instance if I select week 01, I would like to see wk01-wk04 for January.

How would you do that in Power BI?

[v-stephen-msft]

Hi @joshua1990 ,

If you select a week, such as the following, which includes January and February, do you want to filter out a single January, February alone, or both January and February?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[joshua1990]

No ideas?