Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Jyo27
Helper II
Helper II

Selected week and last 3 weeks based on the selected week

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?

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

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.).

vstephenmsft_0-1670393463670.png

 

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.

View solution in original post

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

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.).

vstephenmsft_0-1670393463670.png

 

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
Super User
Super User

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?

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.