Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a Matrix Table with multiple fields as rows

Hi,   I'm trying to re-create the below excel table in Power BI.  I believe it needs to be built as a matrix table but I'm struggling to get it built.   The table in excel has Employee, Mem...
  • PaulDBrown's avatar
    6 years ago

    Anonymous 

    By the looks of your source table, you need to make the rows into columns and columns into rows to get this table:

    Once you have your data with this structure you can create measures and the visual you are looking for.

    To tranform you source table, follow these instructions:

    1) Select you "Paid" column and under the Transform tab, choose "unpivot other columns":

     

    2) now select the "paid" column and choose pivot column with the options shown below:

     

    Now you have the structure you need. Create the measures for each field (column) and create a matrix with your month in the column bucket and the measures in the values bucket. 

     

     

    Go into the formatting pane, and under values, choose "Show on Rows":

     

    And you will get this result: