Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi all,
I have come across a bit of an oddity. Recently, I have noticed that one column, when used as a slicer or filter, is showing duplicate values.
However, if I explore the data in Table view, it shows 4 distinct values:
Additionally, if I run a DAX query on the column, it also shows only 4 values:
I have tried trimming and cleaning the column. I have also tried replacing some hex characters at the suggestion of another thread, but none of these seem to have any impact.
I'm at a bit of a loss here, so any suggestions or insight are greatly appreciated!
Did you ever solve this? I am having the same exact issue and am befuddled. My model shows now duplicates, and yet there are duplicates in the slicer; some of which aren't fully selectable.
If you have not done so already, go into Power Query and get a distinct list of values from the column in question.
One of the easiest ways of doing that is populating a blank query with
= Table.Distinct(Table.SelectColumns(tableName, {"ColumnName"}))
Proud to be a Super User! | |