icon/condition format in card

[Anonymous]

how to create a icon in card visual to indicate the change of a data value?

[Biancagillybi]

You can create a DAX If measure with emojis.

Tutorial Link: https://www.linkedin.com/posts/biancagilchrist_powerbi-dax-designtips-activity-7023385135290990592-q...

[v-chenwuz-msft]

Hi @Anonymous ,

Please try DAX UNICHAR(number) and the number you can refer this unicode list.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Create a unichar measure for arrow

/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)

and you can do conditional formatting using field value option
/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

UNICHAR - Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50