Power BI Text Spilling / Overflow Matrix

[rasknud33]

Hi all

I have matrix with a hierarchy consiting of 6 levels (L1-L6) in Power BI
When I open the hierarchy there a some blank cells and I end up with text overflow / spilling. Is there a way for the text to stop once the cell stop regardless of the adjacent cell being blank? 
I see there is a lot of options in excel. Does some of these exist in Power BI? (I know I could replace all blanks with a 0 but trying to avoid that.
How to stop text spilling over in Excel (ablebits.com)

Your help is highly appreciated

Best regards,
Jesper

[Anonymous]

Hi @rasknud33 ,

Please check whether the "Text Wrap" function is turned on in matrix format.

Result is as below.

Best Regards,
Rico Zhou

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

[rasknud33]

Hi @Anonymous 

Thank you very much for your suggestion and for taking the time.
Comparing with your matrix, it is the 'Level1' and 'Level2' columns where I want to prevent text overflow / spilling to the adjacent cell and not the 'Sum of Value1' 'Sum of Value2' columns. However, the texts in my 'Level1' and 'Level2' are very long and therefore text wrap is not an option as it would take way to much space in the matrix. I have seen in excel that some people are making text wrap and subsequently edit the row height to be "normal" height. I have tried to do the same in Power BI with the Fomat>>Grid>>Row Padding option but does not seem to work.

I would appreciate if you have any other ideas of how this can be solved.

Best regards

[mahenkj2]

Hi @rasknud33 ,

Although you may have genuine need of keeping such large text, as a best practice, I think that you may review such need. Reason is, we would ideally need excellent visualization show business insights definietly with soem decent level of aesthetics. Can you use some simpler words in that level, perhaps original data source have data like that, can you look up with another table and replace that or something like that.

In the end, if you can manage to do so, your matrix visual or any other further visualization will appear more pleasing.

Hope it helps.

[rasknud33]

Hi @mahenkj2 

Thank you for sharing your insight. However, it is a business requirement to show the key and the entire title in the 'Level1' and 'Level2' hierarchy. I do not have data or possibility to show text with simpler words. I have tried to only show the key in the matrix row hierarchy, and then have the title in a tooltip when I hoover the 'Level1' and 'Level2' hierarchy. However, this does not seem to work for matrix rows, only for matrix values.

Best regards