Reply
BartDK
Frequent Visitor
Partially syndicated - Outbound

Switch position of the column headers in Matrix

Hi!

 

This is my first post in the Power BI forums, so nice to meet you all.

 

I'm trying to create some finance reporting with a few basic measures such as actuals, budget, variance budget, forecast, forecast variance, previous year (PY), variance previous year, etc. Ideally, all of these calculations are calculated for both month, year-to-date (YTD) and full year (FY).

I've created calculation groups for: 

  • Actuals
  • Budget
  • Var Budget
  • Forecast
  • Var Forecast
  • PY
  • Var PY

and a parameter with the calculations:

  • Month
  • YTD (TOTALYTD)
  • FY (CALCULATION with ALL filter)

 

When I put all of this into a matrix, I get the following result. Which is fine when I use the parameter slicer to either select month, YTD or FY. But when I want to show two or all three of those at the same, then ideally those three categories should be shown at the top and not at the bottom.

 

Month/YTD/FY at the bottom (repeated for each calculation group):

Screenshot 2024-05-22 171704.png


When Parameter is filter, it's fine:

Screenshot 2024-05-22 171845.png

 

The ideal matrix visual would be like this:

Screenshot 2024-05-22 172313.png

 

I've tried the following:

  • Instead of the calculation groups, I would create them as measures and add an extra column in the parameter that groups them by month, YTD and FY. This doesn't seem to work, because they all get shown for each category anyway

 

These are pictures taken by a dummy file which I've put in Google Drive. Here's the link to the Dummy File.

 

Any help or information would be appreciated!

3 REPLIES 3
v-heq-msft
Community Support
Community Support

Syndicated - Outbound

Hi @BartDK ,
According to your description, if you want to realize the matrix structure you want. You can try to use the current Month,YTD,FY as calculation columns and then break it down into MEASURES in the calculation group you are in to put into the values of the matrix. This is how you will realize the hierarchy on the columns in your matrix.

Create a matrix visual in Power BI - Power BI | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Syndicated - Outbound

Hi Albert,

 

Could you elaborate on this solution?

I've read the page that you've shared but I'm not sure how I would create a column, not a measure, based on other values or calculation groups. And how do I relate the calculation groups to the calculation columns that I've created?

Syndicated - Outbound

Hi @BartDK,
In power bi's matrix, if you want to create a column header with a hierarchy, you need to have a column that you can use as a root and then use MEASURE to populate the VALUE in the matrix. This will ensure that your visual objects are displayed in the upper part as you expect Month, YTD, FY.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)