Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet 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
Hi
I'm trying to fix/set the row header heights on my Matrix visual so that it looks like this:
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):
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:
but it just inserts a blank space.
Any help or guidance would be much appreciated!
Solved! Go to 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:
We can create a calcualted column :
Column = LEFT([Column1],10) & UNICHAR(10) & MID([Column1],11,50) & UNICHAR(8203)
Then we can get this result:
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, @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:
Then the row header will wrap when it is too long:
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:
I'd like all the rows to have equal heights:
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:
We can create a calcualted column :
Column = LEFT([Column1],10) & UNICHAR(10) & MID([Column1],11,50) & UNICHAR(8203)
Then we can get this result:
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:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
146 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |