The same text is show twice in a slicer

[ThomasWeppler]

Hi power Bi community

I have a problem. my slicer shows the same text twice like this.

This is my Dax sorry for the Danish:

Sandsynlighed =

IF('4072 Hoved opgave'[Status] = "Planlagt/aktiv", "Igangværende sager",

IF('4072 Hoved opgave'[Status] = "Afventer", "Igangværende sager",

IF('4072 Hoved opgave'[Status] = "Afventer planlægning", "Igangværende sager",

IF('4072 Hoved opgave'[Status] = "Retur", "Igangværende sager",

IF('4072 Hoved opgave'[C_Sandsynlighed_19] = "Sikker", "Sikre",

IF('4072 Hoved opgave'[C_Sandsynlighed_19] = "Mulig", "Mulige",

'4072 Hoved opgave'[C_Sandsynlighed_19]))))))

It seems like the multiple versions of "Igangværende sager" isn't added together even though they have the same name.

Can anyone help me solve this problem ?
Alle help is greatly appriciated.

[Anonymous]

Hi,@ThomasWeppler .
It's great to see that you solved your problem and that you shared the method to the forum,
you can mark your option as a solution which will help other users in the forum.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[ThomasWeppler · Accepted solution]

When I deleted the column and create a new one that is an exact Crtl+c of the DAX it works fine.

It seems very werid. It might be a bug, because I have changed the column at some point.

I will see if I use the old colum somewhere with measure killer and than just use my new column.
Thanks for the help to everybody who wrote. 🙂

[saud968]

Check for Hidden Characters: Sometimes, extra spaces or hidden characters can cause what appears to be identical text to be treated as different. Ensure there are no trailing spaces or hidden characters in your data.

Normalize the Text: You can use the TRIM and CLEAN functions in DAX to remove any extra spaces or non-printable characters. For example:

NormalizedStatus = TRIM(CLEAN('4072 Hoved opgave'[Status]))
Combine Conditions: Instead of repeating the same output for multiple conditions, you can combine them into a single condition. This can help ensure consistency.

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!

[danextian]

hi @ThomasWeppler 

Is the field on the slicer your calculated column? The same value appearing more than once in a slicer is possibly because the same value has multiple custom sort values which can be forced using Tabular Editor. If that isn't the case, then your scenario is an odd one. I would just modify the formula to this instead:

IF (
    '4072 Hoved opgave'[Status] = "Planlagt/aktiv"
        || '4072 Hoved opgave'[Status] = "Afventer planlægning",
    "Igangværende sager",
    IF (
        '4072 Hoved opgave'[Status] = "Afventer",
        "Igangværende sager",
        IF (
            '4072 Hoved opgave'[Status] = "Retur",
            "Igangværende sager",
            IF (
                '4072 Hoved opgave'[C_Sandsynlighed_19] = "Sikker",
                "Sikre",
                IF (
                    '4072 Hoved opgave'[C_Sandsynlighed_19] = "Mulig",
                    "Mulige",
                    '4072 Hoved opgave'[C_Sandsynlighed_19]
                )
            )
        )
    )
)

If this still doesn't work, I would wrap the whole formula with TRIM()

[Rupak_bi]

hi @ThomasWeppler ,

If you have created a calculated column with this dax and using that column in the slicer, It should work (. please share sample dataset to better understand.