Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Matrix with columns with mixed dimension columns

I'm looking for suggestions on how to create a matrix table where some of the columns are based on a dimension (like month) but at last one is just a total not broken down by month. I would like to do this without having to create a measure for each column.


Below is what I would like to see but this uses a measure for every single column.



Below is what it look like with Fiscal Year and Fiscal Month as columns in the matrix visual. Unfortunately I then get Plan broken down by month when I only want to see the total for Plan but the months for the Forecast and Actuals.




Super User
Super User

Here is one way:

Creating a custom matrix 


and another example

Add a second column to matrix header 

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.