Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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

Anonymous
Not 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/

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.