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 nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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...
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 58 | |
| 51 | |
| 41 | |
| 30 | |
| 24 |