Slicer include and exclude functions

[Nav777]

Hi All, 

I have Fiscal Year slicer and Week sort Slicer .In Fiscal Year Slicer i had Blank, 2022-23, 2023-24, 2024-25 in drop down and in Week sort Slicers I have 53 week Drop down weeks which you can select. I was trying to remove the blank from it which i did , I right click and exclude from it, then i realise it basically i am applying a filter on and i have reset it but now When i select Fiscal Year slicer every thing else is working fine except when i select 2024-25 it automatically bring the Week sort slicer to week 1 and filter the Data to only week 1. I am trying to reset this as when i select year 2024-25 then i can have all the weeks drio down to 1-53. I cannot find anywhere 

[Anonymous]

Hi, @Nav777 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Your slicers need to be fed from disconnected tables. Use measures to read the slicer values and filter your visual accordingly.