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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
hilda_fernandez
Frequent Visitor

Use unichar(10) in custom label to add data in next line

Is there a way to add a unichar(10) in a custom label the same way it works in a measure?

I have a 100% stacked column where I want to add 3 different measures in the data label. I was able to add them separated by a " [" but text is too long for them to be seen in the bars, so I'd like to move the third measure to another line.

I tried adding unichar(10) between measures and works great for example in a data card, but label will still show it as a space

4 REPLIES 4
cstjohn
Regular Visitor

 I have this same issue.  I have created a measure for my Custom label but would like for it to wrap or have a carriage return in between the value and % of total.  I can get the label to show but once I add months, it disappears since the label is large altogether.   Below is how I want it to look (left = Excel) vs what it looks like in Power BI (right).  Just curious if you found a workaround!

cstjohn_0-1695298405192.pngcstjohn_1-1695298437243.png

 

Ahmedx
Super User
Super User

Hi Ahmed, this video is really good. I found that in my dataset it worked great for one column of data but then needs a bit more work when additional column/cluster required (e.g. monthly comparison, where column legend previously used), if any further tips there?
Thanks

Update - I realise can add say month/year to X axis as well but not necessarily how want to present the data (i.e. no cluster per se, and spaces between all columns)

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.