Forum Discussion

HamidBee's avatar
HamidBee
Icon for Power Participant rankPower Participant
4 years ago
Solved

Why is my DAX not displaying ✅?

Attached please find the .pbix file. I have the following DAX expression:

 

 

The problem is the tick never displays. Here is the output whenever I select something:

 

As you can see, it always displays as crosses. 

  • I've just solved it. If you put a space just before the tick, it works. Strangest thing ever. Here is what I did:

     

3 Replies

  • From what I can see it may be a result of the table visual containing letters from table 1 so the selectedvalue test should be applied to table 1 letters.
    I wrote a quick slicer 3 measure

    Slicer3 =
    IF (
        SELECTEDVALUE(Table1[Letter]) = SELECTEDVALUE(Table2[Letter]),
        "yes",//"",
        "no"//""
    )
    and get the result

    but as soon as I apply the icons in place of the yes/no text I get each line populated with the same icon.
    Hope this gets you going in the right direction.

    • HamidBee's avatar
      HamidBee
      Icon for Power Participant rankPower Participant

      I've just solved it. If you put a space just before the tick, it works. Strangest thing ever. Here is what I did:

       

  • It appears to be a bug with unicode characters. If you replace the X with "no", then it works as expected. if either of the return clauses contains text and the other contains unicode then it works fine, but if both clauses contain unicode then it always returns the else part. raise it as a bug.