The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"?
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.