Line break and UNICHAR DAX

[Anonymous]

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 · Accepted solution]

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

[Anonymous]

Did you try CHAR(10) in SSAS? Maybe the following article could help you.

https://bpmsbi.wordpress.com/2010/12/15/line-breaks-in-ssrs/

[Anonymous]

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