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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
JFarq
Helper I
Helper I

Fix/set row header heights in matrix

Hi

 

I'm trying to fix/set the row header heights on my Matrix visual so that it looks like this:

BeforeFormatting - Copy.png

AfterFormatting - Copy.png

  

I've tried padding out each row header statement with whitespace in a new custom column using the following m language (where 'Attribute' is the row header field renamed 'Student Voice' in the matrix and 138 is the length of the longest row header string):

JFarq_0-1678365341435.png

but text wrap in the matrix formatting seems to ignore any whitespaces and it's the same as it was before.

 

I've also tried creating a new column with DAX and using the linebreak UNICHAR(10) somewhere in the row header strings:

JFarq_1-1678365755315.png

but it just inserts a blank space.

 

Any help or guidance would be much appreciated!

 

1 ACCEPTED SOLUTION

Hi , @JFarq 

Based on my testing and research, as with your results, the matrix ignores newline characters and empty strings.

To realize your need , you need to add a Ghost placeholder by "UNICHAR(8023)".

This is my test data:

vyueyunzhmsft_0-1678756697989.png

We can create a calcualted column :

Column = LEFT([Column1],10) & UNICHAR(10) & MID([Column1],11,50) & UNICHAR(8203)

 

Then we can get this result:

vyueyunzhmsft_1-1678756752493.png

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

4 REPLIES 4
v-yueyunzh-msft
Community Support
Community Support

Hi, @JFarq 

According to your description, you want to show all the text in the row header instead of the "....".

If this ,you can try to open the "text wrap" of the row header:

vyueyunzhmsft_0-1678671380346.png

Then the row header will wrap when it is too long:

vyueyunzhmsft_1-1678671409958.png

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi Aniya

 

Thanks very much for your message.

 

I've tried text wrap, but the rows vary in height because of the different statement string lengths:

IveTriedThisButRowsHaveDifferentHeightsBecasueofDifferentStringLengths - Copy.png

I'd like all the rows to have equal heights:

AfterFormatting - Copy - Copy - Copy.png

 

 

Hi , @JFarq 

Based on my testing and research, as with your results, the matrix ignores newline characters and empty strings.

To realize your need , you need to add a Ghost placeholder by "UNICHAR(8023)".

This is my test data:

vyueyunzhmsft_0-1678756697989.png

We can create a calcualted column :

Column = LEFT([Column1],10) & UNICHAR(10) & MID([Column1],11,50) & UNICHAR(8203)

 

Then we can get this result:

vyueyunzhmsft_1-1678756752493.png

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi Aniya

 

Wow, that's great! Thank you!

 

I used the formula:

AttributeGhost = IF(LEN(Table242[Attribute]) < 76, Table242[Attribute] & UNICHAR(10) & UNICHAR(8203), Table242[Attribute])

 

To get the desired output:

WorkingFormatting.png

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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