March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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?
Solved! Go to 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.
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.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |