Forum Discussion

anil2's avatar
anil2
Frequent Visitor
8 years ago
Solved

UNICHAR DAX function does not exist in Power BI Desktop

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi anil2,

     

    Based on my test, if we are connecting to SSAS tabular cube in Direct Query mode, UNICHAR() function is not supported. 

     

    Best regards,

    Yuliana Gu

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

HI anil2

 

It should do, you just need to 1) make sure the value you use is base-10 and a valid unichar character and 2) use a visual that supports them

 

Measure = UNICHAR(128077)

produces a thumbs up

 

anil2's avatar
anil2
Frequent Visitor
8 years ago

Thanks. But I am seeing a redmark under UNICHAR when i am trying to create a mesue. It looks like function not available on my destop  version. Please suggest.

 

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    What version of Power BI Desktop are you using?

     

    The UNICHAR function was added approx 6 months ago.

    • anil2's avatar
      anil2
      Frequent Visitor
      8 years ago

      2.56.5023.942 64-bit (March 2018)

      • Phil_Seamark's avatar
        Phil_Seamark
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        HI anil2

         

        That should be recent enough.  Perhaps it is the value you are passing to it.  Are you trying to pass text???

         

        What happens if you try to generate the calculated measure I suggested in your model?

         

        Test Measure = UNICHAR(128077)