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,
can someone please advise how to add a line break in a tabuarl model measure.... like if we wanted to display a card with value on multiple lines as below
% of orders
4 / 16
25%
I used this DAX which returns correctly in Power BI desktop DAX
RETURN
Numerator & "/" & Denominator
& UNICHAR ( 10 )
& IF(ISBLANK(ROUND ( DIVIDE ( Numerator, Denominator ) * 100, 0 )),0,ROUND ( DIVIDE ( Numerator, Denominator ) * 100, 0 )) & "%"
When I take this in visual studio for tabular model UNICHAR does not work as it is not recognized. Can someone please advise if there is an alternate way to do it. Once measues are coming from Tabular model we cannot do anything in Powrer BI desktop.
Many thanks
Use separate measures and separate visuals.
Hi @lbendlin Thanks for the reply. It is not what is required as it slows down the page load. Can we do inside one measure? Is there a way?
Have a look at calculation groups.
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 |
---|---|
47 | |
24 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |