Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
I have a dataset here
I need to create a matrix chart that looks like this
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?
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.
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 , 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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
73 | |
57 | |
38 | |
35 |
User | Count |
---|---|
83 | |
68 | |
59 | |
46 | |
45 |