Forum Discussion
Helper IHow to automate adding columns in matrice visual
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.
Super UserHii 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.