Forum Discussion
Helper IHow 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 column by a copy / past from a excel for excel instead of drag and drop one by one my column
thx
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.
2 Replies
rohit1991Super User
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.
- lbendlin
You can use PBIR to construct your matrix visual from scratch.
