Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
I would like to create a Matrix visual that looks like below where I have merged column headers (cars, trucks, suv's).
How can I add the merged headers?
Solved! Go to Solution.
Do those tables share the same structure? If they do, it would be better to combine them into a single table with an additional column to indicate the vehicle type. You can use the append feature in the query editor.
Hi @ERing
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
I wish you have explained it upfront. Better to combine (append) these tables as one table and then use what I suggested in my original reply.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@ERing In a matrix visual, whatever the column stores the value "Car/Truck/SUV" will be on the column, in the value section, you will use measures (actual/baseline/data) and the rows will have the location column.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
My data for each category (cars, trucks, & suv's) are in different tables. So I have a "cars" table, a "trucks" table, and an "suv" table.
I don't have a column that stores "car, truck, suv" values.
Do those tables share the same structure? If they do, it would be better to combine them into a single table with an additional column to indicate the vehicle type. You can use the append feature in the query editor.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
77 | |
76 | |
69 | |
48 | |
40 |
User | Count |
---|---|
62 | |
41 | |
33 | |
30 | |
29 |