Forum Discussion

Piyush_Ghungrud's avatar
Piyush_Ghungrud
Helper I
3 years ago
Solved

Horizontal Scrollbar not functional after adding few more fields to the matrix

Hi Community,

 

I have been working on a matrix where I have created a Field Parameter and added it to the column of the matrix.

On multiselect, the fileds get appended in the matrix column, however after certain number of fields added, the horizontal scrollbar which was appearing and working fine, becomes unfunctional.

Is there any limit to adding fileds in columns of the matrix so that the scrollbar works fine?

Please help on this.

Thanks in advance.

Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , Piyush_Ghungrud 

     According to your description, when you add a  Field Parameter and added it to the column of the matrix. When the number of fields added , the horizontal scrollbar becomes unfunctional.

    For this i searched , the official document says:

    Scroll bars will appear to help you scroll across body cells which don't all fit on the visual at once, but row header columns are fixed on the matrix visual and will not scroll. If you include too many row headers in your matrix such that the body cells are hidden, scrolling will not reveal the body cells. Instead, reduce the number of row headers on your visual, adjust column width, reduce font size, or otherwise ensure the matrix body cells are visible in order to access your value data.

     

    So when you continue to increase your Column level, the row headers will increase, and problems may arise. In addition, I also found similar questions about this case:

    Matrix not allowing horizontal scroll in Power BI ... - Page 2 - Microsoft Fabric Community

     

    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

     

     

2 Replies

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

    Hi , Piyush_Ghungrud 

     According to your description, when you add a  Field Parameter and added it to the column of the matrix. When the number of fields added , the horizontal scrollbar becomes unfunctional.

    For this i searched , the official document says:

    Scroll bars will appear to help you scroll across body cells which don't all fit on the visual at once, but row header columns are fixed on the matrix visual and will not scroll. If you include too many row headers in your matrix such that the body cells are hidden, scrolling will not reveal the body cells. Instead, reduce the number of row headers on your visual, adjust column width, reduce font size, or otherwise ensure the matrix body cells are visible in order to access your value data.

     

    So when you continue to increase your Column level, the row headers will increase, and problems may arise. In addition, I also found similar questions about this case:

    Matrix not allowing horizontal scroll in Power BI ... - Page 2 - Microsoft Fabric Community

     

    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