Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
PBINewbie920
Helper I
Helper I

create header for columns in matrix?

‎02-03-2022 11:37 AM

Hi! 

I currenly have a data set with many columns I created with DAX (so i am unable to unpivot them)

 

my columns currently look like this (in a matrix):

2021 Orders2022 Orders2021 Revenue2022 Revenue

I want headers to group "Orders" and "revenue" to clean it up, like this: 

Orders           Revenue

2021202220212022

 

How can I do this?

Thank you! 

Labels:
Message 1 of 2
443 Views
0
1 ACCEPTED SOLUTION
TheoC
Super User
Super User

‎02-03-2022 03:42 PM

Hi @PBINewbie920 

 

In your Matrix table, under the Columns field add Orders and Revenue first, then underneath that addd the Years.

 

If you're data model is structured appropriately, the above should work. If not, please let us know and we can further assist.


Theo 🙂

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

Message 2 of 2
392 Views
1 REPLY 1
TheoC
Super User
Super User

‎02-03-2022 03:42 PM

Hi @PBINewbie920 

 

In your Matrix table, under the Columns field add Orders and Revenue first, then underneath that addd the Years.

 

If you're data model is structured appropriately, the above should work. If not, please let us know and we can further assist.


Theo 🙂

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Message 2 of 2
393 Views

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Kudoed Authors
View All