Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi,
How can I have Multiple columns as Attributes in Matrx in Power BI? I have Text and Numeric Fields as well which I need to list them as Columns next to each other & then have some measures as columns next to them. For example
Category(Text) Cost_Range(Num) Date1 Date1 Measure1 Measure2 Measure3.....
The moment I put Cost_Range field in rows it's going to drill down option, I need it next to Category field instead.
Is there a way?
Thanks
Hi DataUPBI,
Could you share some sample data and clarify more details about your requirement?
Regards,
Jimmy Tao
You can turn off the stepped view which makes the data appear in a tablualr format but you still need to drill down.
MS have promised Excel like matrix/cross tab functionality soon that may help.
Demoded here (39 mins) - https://www.microsoft.com/en-us/businessapplicationssummit/video/BAS2018-204
Mentioned here - https://docs.microsoft.com/en-us/business-applications-release-notes/october18/intelligence-platform...
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 17 | |
| 11 |
| User | Count |
|---|---|
| 55 | |
| 53 | |
| 43 | |
| 36 | |
| 32 |