Forum Discussion

JFarq's avatar
JFarq
Helper I
3 years ago
Solved

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:    I've tried padding out each row header statement with whitespace in a new custom c...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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

JFarq's avatar
JFarq
Helper I
3 years ago

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:

 

 

 

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

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

  • JFarq's avatar
    JFarq
    Helper I
    3 years ago

    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: