Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

select all columns

Hello! I have a matrix with almost 100 columns related to products.

I need to size all columns.

How can I select all columns and size them equally and at the same time ( like in Excel)

Thanks 

Tips and Tricks
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    The column width will be auto-sized if the option is on. If you'd like to resize them at the same time manually, I would suggest you vote up this idea.

     

    Best Regards,

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    Hi Anonymous,

     

    This is not possible in PBI you cannot edit size of columns simultaneous in matix or table visuals.

     

    Let me just make a question why do you have a matrix visual with over 100 columns in PBI this is not practicall to analyse and information will get confusing. PBI is not the same has excel and as different purposes and using the same ways of working will lead to incorrrect conclusion or very difficult to analyse files.

     

    Regards,

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yes , thanks but i have to use all the products.

      Thanks a lot

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous,

         

        The column width will be auto-sized if the option is on. If you'd like to resize them at the same time manually, I would suggest you vote up this idea.

         

        Best Regards,