how to get this icon in a dax measure?

[Anonymous]

Hi

I've had this dax measure for a while which i got help on from another user - however i've been trying to figure out how they were able to add this icon into the dax measure but have had no luck.

Does anyone know how this is done? (the green and red circle)

Expiry warning = var __diff =

DATEDIFF(MAX(Pipeline[Delivery Date] ) , MAX(Pipeline[Approval Expiry Date]),MONTH ) return IF( HASONEVALUE(Pipeline[Delivery Date] ), IF( __diff <= 3 , " 🔴 " & __diff & " months" ,"🟢 " & __diff & " months" ) )

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

Please try this:-

Expiry warning =
VAR __diff =
    DATEDIFF (
        MAX ( Pipeline[Delivery Date] ),
        MAX ( Pipeline[Approval Expiry Date] ),
        MONTH
    )
RETURN
    IF (
        HASONEVALUE ( Pipeline[Delivery Date] ),
        IF (
            __diff <= 3,
            UNICHAR ( 128308 )  & __diff & " months",
            UNICHAR ( 128994 ) & __diff & " months"
        )
    )

Thanks,

Samarth

[Anonymous]

Ah okay thats great to know!
Thank you for that.

Would you mind just explaining where the unichar(*****) comes from?

[Samarth_18 · Accepted solution]

@Anonymous Basically the UNICHAR() DAX function is a text function that takes a numerical Unicode value and displays its associated character.  There different number for different type of icons.

[Anonymous]

Right okay that makes alot more sense.

Thank you so much for your help!!

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

Please try this:-

Expiry warning =
VAR __diff =
    DATEDIFF (
        MAX ( Pipeline[Delivery Date] ),
        MAX ( Pipeline[Approval Expiry Date] ),
        MONTH
    )
RETURN
    IF (
        HASONEVALUE ( Pipeline[Delivery Date] ),
        IF (
            __diff <= 3,
            UNICHAR ( 128308 )  & __diff & " months",
            UNICHAR ( 128994 ) & __diff & " months"
        )
    )

Thanks,

Samarth