Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Line break and UNICHAR DAX

Hi All,

 

I am using UNICHAR dax for line break in a measure. It's working fine in Power BI Desktop however we need to replicate same on SSAS model. But UNICHAR is not supported on SSAS yet.

 

Is there any other way I can replace UNICHAR with some other DAX? Or any other way for line break?

 

My measure: 

IF(ISFILTERED(d_OPP_Geography[Market Group]),"Market Group: "& CONCATENATEX(ALLSELECTED(d_OPP_Geography[Market Group]),d_OPP_Geography[Market Group],",")&UNICHAR(10),"")&
IF(ISFILTERED(d_OPP_Geography[Market]),"Market:"&CONCATENATEX(ALLSELECTED(d_OPP_Geography[Market]),d_OPP_Geography[Market],","))

 

Thank you,

Niket Talati

  • Anonymous's avatar
    Anonymous
    8 years ago

    Got to know that it's supported in SSAS 2017. 

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous,

       

      Thank you for your response.

      CHAR(10) is not supported in SSAS, the blog which you shared it's realted to SSRS (reporting). So I doubt it can help me since CHAR is not a DAX.

       

      Regards,

      Niket Talati

  • Anonymous's avatar
    Anonymous
    Not applicable

    Got to know that it's supported in SSAS 2017.