how can i place 2 columns in a matrix table in Power BI

Hi Gunja S Shah,

Thank you for reaching out to us on Microsoft Q&A forum.  

To create a matrix table in Power BI that displays functions in rows, location-wise values of employees in columns, and includes categories such as Trainees, JMC, MMC, etc., follow these steps:

Steps to Create the Desired Matrix Table

1. Load Your Data: Ensure your data is properly loaded into Power BI and contains fields for Functions, Locations, Categories (e.g., Trainees, JMC, MMC).

Create a Matrix Visual:

• Open Power BI Desktop.
  • From the Visualizations pane, select the Matrix visual to create an empty matrix on the report canvas.

1. Add Fields to the Matrix:

• Rows: Add the Functions field to the Rows area.
  • Columns: Add the Location field to the Columns area first, then add the Category field (e.g., Trainees, JMC, MMC) to the Columns area below the Location.
  • Drag and drop the Category field (e.g., Trainees, JMC, MMC) to the Columns area below the Location. Kindly check the below screenshot.

If you are still facing any issue, please let us know in the comments. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.