Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
68 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |