Slicers get Missing after filtering several values.

[chinaik123]

Hi ,

Not sure if anyone have faced this issue before. I have a 3 slicers that i have created.
Before:  The left slicer controls the left chart and the right slicer control the right chart. The Country Slicer controls everything. 

After:

If i filter the Blue and Grey slicer together, the Country Slicer will be missing.

I am not sure what i did wrongly.

Please help me

[v-sgandrathi]

Hi，

May I ask if you have gotten this issue resolved?

If it is solved, please share the answer with us in the commnity, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi · Accepted solution]

Hi @chinaik123.,

Happy to see you here in the Microsoft Fabric Community! 

Ensure that the data relationships between your tables are correctly set up. Go to Model View and check how the tables are related. Make sure the relationships are correctly linked and use Single Direction filtering unless absolutely necessary.

If your Blue and Grey slicers filter out all available Country values, the Country Slicer may disappear.

Remove all slicer filters and check if the Country values appear again.

Go to Format then Edit Interactions and ensure that the Country Slicer is not being filtered by the Blue and Grey slicers.

Try selecting one value at a time in the Blue and Grey slicers and check if the Country Slicer disappears.

This will help you identify if one specific slicer is causing the issue.

If the problem persists, consider creating a separate lookup table for slicers to avoid unwanted filtering.

Hope my suggestion gives you good idea, if you have any more questions, please feel free to ask we are here to help you.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Thank you.

[v-sgandrathi]

Hi @chinaik123,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or 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.

Thank you.

[chinaik123]

Hi @v-sgandrathi 
I tried it on my end but it is still missing after i remove everything and unfiltered.
Perhaps we can have a call on this please?

[v-sgandrathi]

Hi @chinaik123,

To keep the discussion transparent and helpful for the broader community, may I kindly request you to continue posting your updates and questions here? I’ll be happy to assist you further with the issue through this thread.

Thakn you.

[Ashish_Mathur]

Hi,

Turn off interaction between

1. Blue slicer and Country slicer
2. Grey slicer and Country slicer

[chinaik123]

Hi @Ashish_Mathur 

After turning off the interactions, it is still missing when i filter.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.