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

Gunja S Shah 20 Reputation points
2024-06-08T08:28:24.7066667+00:00

i am creating a matrix table visual which needs to show the functions in rows and location wise values of employees in columns along with categories mentioned as per below image which are Trainees, JMC, MMC etcQ&A1

Q&A1.png

This question is related to the following Learning Module

Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
156 questions
{count} votes

Accepted answer
  1. Syed Saleem Peera 1,395 Reputation points Microsoft Vendor
    2024-06-08T16:17:47.0933333+00:00

    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.

    User's image

    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.


0 additional answers

Sort by: Most helpful