Forum Discussion

rasknud33's avatar
rasknud33
Advocate I
3 years ago

Power BI Text Spilling / Overflow Matrix

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      rasknud33
      Advocate I
      3 years ago

      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's avatar
        mahenkj2
        Solution Sage
        3 years ago

        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.