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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How do I group columns by category in the same pivot table in excel?

Good afternoon guys, what's up? I need some help

I'd like to layout the PowerBi "Matrix" in the same way that the "Pivot Table" groups the categories before showing the value, as shown in the photos below.

1. Excel - Pivot Table

In the image below we can see that the pivot table first categorizes the values - Volume/Weight and Volume Measure - before grouping by BAT/PMI and JTI
Excel.png

2 - Power BI - Matrix
In Power BI, the "Matrix" does just the opposite, first it categorizes BAT/PMI/JTI and then it categorizes the values
Power BI.png

I would like to know if it is possible to visualize the "Pivot Table" (example of photo 1) in PowerBI with "Matrix"?

1 REPLY 1
lbendlin
Super User
Super User

This is the dreaded "measures as column headers"  pattern.

 

You need to have a disconnected table with the precomputed variations of your measure names.  Use that to feed the column part of the matrx visual , and then use another measure to sense where in the matix you are (see what I did here?) and to supply the appropriate measure value.

 

Or - don't.  Don't try to make Power BI to be like Excel. Don't waste your time, embrace Power BI as it is.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors