Forum Discussion
Slicer not showing correct data
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 💡
Super UserHi 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 💡