Forum Discussion
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
- Anonymous8 years ago
Got to know that it's supported in SSAS 2017.
3 Replies
- AnonymousNot applicable
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/
- AnonymousNot 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
- AnonymousNot applicable
Got to know that it's supported in SSAS 2017.