Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
LaurenLai
Frequent Visitor

How to create subheader for columns and allow measure to be pulled to column in matrix chart?

I have a dataset here

LaurenLai_0-1688886048564.png

 

I need to create a matrix chart that looks like this

LaurenLai_1-1688886098007.png

 Initially I tried it to do with measure, it works but I could not create the subheading like "A", "B", or "Total". I also tried to pull the measure of total time into the column of matrix, but it is not working as well.

 

Does anyone have an idea on how to do this?

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @LaurenLai 

 

This is my result. You can download the pbix file attached at bottom to see the changes I have made. It requires quite some work because the current table format cannot meet the need. I have added some tables and measures to help get the expected result. 

vjingzhang_0-1689056910771.png

For the Total Time column, I currently return its result in seconds. To get it returned in "hh:mm:ss" format, we may need to create a calculation group. Let me know if you have any questions. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Hi Jing,

 

Thank you so much for your work and reply! Would you mind explain the dax for number of records? I don't quite get it. I ran the code, the total ans and total no ans column showed 0 for all rows.

 

LaurenLai_0-1689515987662.png

 

amitchandak
Super User
Super User

@LaurenLai , That needs some work around

 


if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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