Forum Discussion

JFarq's avatar
JFarq
Icon for Helper I rankHelper 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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity 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
Icon for Helper I rankHelper 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: