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,

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,