Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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!
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! | |
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
43 | |
41 | |
39 | |
36 |