Forum Discussion

ShaunLeMouton's avatar
ShaunLeMouton
Icon for Helper I rankHelper I
9 months ago
Solved

How to automate adding columns in matrice visual

Hi   I have a very big table with lot of columns. In the rigth panel (Datas) the columns are order by name. I would like to know if there is a trick to put in a matrice visual for example the col...
Need Help
  • rohit1991's avatar
    rohit1991
    9 months ago

    Hii ShaunLeMouton 

     

    At the moment, Power BI doesn’t offer a bulk-add option for Matrix fields (such as copy/paste or multi-select). The Matrix accepts fields only one at a time.

    However, you can make this much easier by restructuring the data:

    1. Unpivot your wide table :This converts many separate columns into rows, so the Matrix automatically shows them without dragging each one.

    2. Use a Field Parameter :Create a field parameter with all your columns  then simply place that one parameter in the Matrix, and Power BI handles the rest.

    3. Create a proper dimension table :Move your column names into a dimension. The Matrix will then display them dynamically.