Power BI Matrix Visual: Add the column from second matrix as the first column in the first matrix

[lakjain27]

Hi all,
I have two matrices in Power BI. I want to add the column from the second matrix as the first column in the first matrix. Is this possible in Power BI, and what’s the best way to achieve it?

I would like to achieve a result in Power BI similar to what I have in Excel, where I can add an AVG column to my matrix. Specifically, I have two matrix visuals in Power BI:

• First matrix:

  • Rows: Description, DMA Name
  • Columns: Month, Year
  • Values: Total Sum

• Second matrix:

  • Rows: Description, DMA Name
  • Values: Total AVG

In Excel, I am able to place the average as a separate column alongside my main table. I want to replicate this in Power BI by adding the AVG measure (from the second matrix) as the first column in the first matrix, so users can see both the AVG and the monthly/yearly totals in a single view.

Currently, if I try to add the Total AVG measure to the first matrix in Power BI, it calculates the average for each month and year instead of displaying a single AVG column. This breaks the intended layout. I want the Power BI matrix to look like my Excel table, with the AVG as a fixed first column, followed by the monthly/yearly columns.

How can I achieve this layout in Power BI?