Forum Discussion

vamshikrishna20's avatar
vamshikrishna20
Icon for Helper III rankHelper III
5 years ago
Solved

Unichar for flag symbol

Hi Everyone,    can someone help me with unichar for below shown flag symbol. Thanks in Advance      
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    Hi vamshikrishna20   

     

    You can use below code. It will allow you change color of flag based on your requirement.

    Flags = UNICHAR(9873)

     

    Output:- 

     

    Thanks

  • v-luwang-msft's avatar
    5 years ago

    Hi vamshikrishna20 ,

    Since unichar(128681) is a fixed graphic, so it can't change color, you can Samarth_18's solution, or replace it with another similar graphic to unichar(128681) another color.(refer:https://www.alt-codes.net/flags )

    Flag Symbol Flag Name Unicode Hex HTML Dec Code(use in dax)
    🏁 Chequered Flag U+1F3C1 &#127937
    🚩 Triangular Flag U+1F6A9 &#128681
    🎌 Crossed Flags U+1F38C &#127884
    🏴 Black Flag U+1F3F4 &#127988
    🏳 White Flag U+1F3F3 &#127987
    🏳️‍🌈 Rainbow Flag U+1F3F3 U+FE0F U+200D U+1F308 &#127987 &#65039 &#8205 &#127752
    🏴‍☠️ Pirate Flag U+1F3F4 U+200D U+2620 U+FE0F &#127988 &#8205 &#9760 &#65039

     

    All unichar correspondence diagrams: https://www.vertex42.com/ExcelTips/unicode-symbols.html 

    Similar questions refer:(in this case ,he use  unichar(127937) and unichar(128681))

    https://forum.enterprisedna.co/t/dax-excel-v-lookup-equivalent-to-record-a-fine-one-record-as-a-starter/13564/2 

     

    Wish it is helpful for you!

     

    Best Regards

    Lucien