Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Duplicate values in selection filter

Dear

Along with greeting, I have a problem with the selection filter where certain values appear duplicates to me.

I have checked the source, and all the data is well written (there are no spaces left, no different characters), so it is strange that in the filter appears Chile, El Salvador, Guatemala, Panama at least 2 times repeated.

Is there a solution?

Greetings and thanks in advance!

3 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    I found the error, the data in the source, were separated as ", "and not ",", for that same reason, there were duplicate countries because there were rows that only had 1 country (example: Panama) and another that had several (Chile, Panama, Honduras).

    Best regards!

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Matias1986 ,

      If I understand correctly, there are duplicated values in the field [Pais], and it seems that it got from a separated column. Could you please provide some raw data in the source field? Thank you.

      If you have the data in the following table, you can follow the steps below to handle with it in Power Query Editor. Please find the details in the attachment.

      let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WStRJ0knWSVGK1YlWStVRSNNRUEjXUcjQyQSLZOlk6yjk6CjkKsXGAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4"}),
    #"Trimmed Text" = Table.TransformColumns(#"Split Column by Delimiter",{{"Column1.1", Text.Trim, type text}, {"Column1.2", Text.Trim, type text}, {"Column1.3", Text.Trim, type text}, {"Column1.4", Text.Trim, type text}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Trimmed Text",{{"Column1.1", type text}, {"Column1.2", type text}, {"Column1.3", type text}, {"Column1.4", type text}})
in
    #"Changed Type1"

      Best Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  Matias1986 ,

    Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

    Best Regards