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.
Hello all,
Is there anything like forcefully getting values into new line..
Per suppose i have 4 sales type of values.
I would like to show each sales type and their values into 4 lines..
we have something like wordwrap but it wont work for all the time.
Do we have unichar no for braking line and getting values into newline.
Any help
Mohan V
Solved! Go to Solution.
Hi @Anonymous,
Seems it doesn't work on the card visual yet.. But here is a workaround. It works with a combination of word-wrap and the UNICHAR(10), so measure remains the same.
Use a table or matrix visual, put the measure in and rename the measure in the visual to " " set the outline color to the same as the background, enable word-wrapon values and it is allmost like the card visual. Probably it will be supported in the near future.
Hi Mohan,
Since the Power BI July update there is support for the UNICHAR that represent a new line:
Measure with newline = "This is the first line" & UNICHAR(10) & "This is the second line"
Check https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary-2/ for more info
Thanks for the reply @Anonymous.
I jus tried this but no luck..
Its not working.
My powerbi Desktop details..
Am i missing anything here..
Hi @Anonymous,
Seems it doesn't work on the card visual yet.. But here is a workaround. It works with a combination of word-wrap and the UNICHAR(10), so measure remains the same.
Use a table or matrix visual, put the measure in and rename the measure in the visual to " " set the outline color to the same as the background, enable word-wrapon values and it is allmost like the card visual. Probably it will be supported in the near future.
Thanks @Anonymous
it works..
great....:)
can you give any suggestion regarding the unichar no for tab space.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |