Selected week and last 3 weeks based on the selected week

[Jyo27]

Hi Everyone ,

I have a requirement where I have to display the selected week data and last 3 weeks data in a column chart. Based on this I've created separate date table and its working fine with the solution provided by this link https://community.powerbi.com/t5/Desktop/Selected-week-and-Last-4-Weeks-Data-Based-on-Selected-Week/...

But I have other slicers including week slicer. Other slicers are not working except week slicer. Can anyone please help me resolve this issue?

[v-stephen-msft · Accepted solution]

Hi @Jyo27 ,

Please try to replace the ALL function with ALLSELECTED function. It removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters(Simply put, it can keep the filters in the other slicers.).

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.

[djurecicK2]

Hi @Jyo27 ,

 I think we need more information. Can you post some screenshots with examples of what is not working and how you would like it to work?