Forum Discussion
Slicers get Missing after filtering several values.
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
Hi Anonymous.,
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.
8 Replies
- Ashish_Mathur
Super User
Hi,
Turn off interaction between
- Blue slicer and Country slicer
- Grey slicer and Country slicer
- Ashish_Mathur
Hi,
Share the download link of the PBI file.
v-sgandrathiCommunity Support
Hi Anonymous.,
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 Anonymous,
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.
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，
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.
