Forum Discussion

MeiYing's avatar
MeiYing
Icon for Helper I rankHelper I
2 years ago
Solved

Image display in Power BI by conditional formatting

Hi,   I want my card visual to display total number of failed orders, but when there is no failed orders, the image (smiling emoji) will be displayed. I created measure (HasfailedOrder = If([failed...
  • Ritaf1983's avatar
    2 years ago

    Hi MeiYing 
    You can just copy and paste the emoji to the DAX code like :

    test emoji = if(sum('Table'[Fail order])=0,"🙂",SUM('Table'[Fail order])&"🙁")
    Result :

    The line of the website for copy emojis :

    https://emojicopy.com/

    pbix is attached

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

  • MeiYing's avatar
    2 years ago

    Thank you so much Ritaf1983 . It really works! But do you know if we can use other images online (not emoji), like by using URL ?