Slicer and table show duplicate options

Hi Echoy51 

 

This happens if those columns are custom sorted mutliple times  (Value A with sort value of 1 and 2) which the GUI doesn't allow but can be enforced using Tabular Editor. But this doesn't seem to be the case for you  so the only plausible reason is there are invisible characters before or after in either of those seemingly duplicate values. You can confirm this by removing duplicates in sorting them in the query editor. You can try as Ritaf1983 suggested. If that doesn't work because the characters cannot be removed by using either Trim or Clean, I would right click one of those cells, click replace and that should show the special character if ther are any.

 

In the screenshot below the invisible character denoted by #(8208) which is possibly a line break. You can leave just this character and replace it with nothing.

 

 

 

Hi Echoy51 
It seems like you have hidden spaces in your data set.
Try to trim and clean it from the PQ  :

if it will not help 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Hi Echoy51 ,
Does danextian  or Ritaf1983  answer solve your problem, if so you can mark their answer as a solution, if not you can continue to ask your question.

 

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly