Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.