Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
HamidBee
Power Participant
Power Participant

Why is my DAX not displaying ✅?

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

 

HamidBee_0-1662652064410.png

 

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

HamidBee_0-1662652729022.png

 

As you can see, it always displays as crosses. 

1 ACCEPTED SOLUTION

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

HamidBee_0-1662656689941.png

 

View solution in original post

3 REPLIES 3
johnt75
Super User
Super User

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.

jgeddes
Super User
Super User

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
jgeddes_0-1662654303181.png

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





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

HamidBee_0-1662656689941.png

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors