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

[Anonymous]

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


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


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

[lbendlin]

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.