Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Got to know that it's supported in SSAS 2017.
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/
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
79 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |