Forum Discussion
Slicer not showing correct data
Hi,
I am working on a dashboard to showcase regional nuances in a data set. I have added a slicer for region and country but when selecting, for example Australia, it is showing Australia and UK which is incorrect. I have checked the data source and there are no issues there. How can I resolve this issue?
Hi imogensg
This usually happens because the slicer field isn’t unique or the relationship is pulling in extra rows.Make sure your Country column comes from a proper dimension table (a clean list of unique countries) and connect it to your fact table with a one‑to‑many relationship, then use that dimension in the slicer instead of the raw fact column.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
3 Replies
- DataVitalizer
Super User
Hi imogensg
This usually happens because the slicer field isn’t unique or the relationship is pulling in extra rows.Make sure your Country column comes from a proper dimension table (a clean list of unique countries) and connect it to your fact table with a one‑to‑many relationship, then use that dimension in the slicer instead of the raw fact column.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡 
v-pnaroju-msftCommunity Support
Thankyou, DataVitalizer for your response.
Hi imogensg,
We appreciate your inquiry through the Microsoft Fabric Community Forum.
We would like to inquire whether have you got the chance to check the solution provided by DataVitalizer to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.- v-pnaroju-msft
Hi imogensg,
We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.
Thank you.