Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register 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...
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 43 | |
| 38 | |
| 34 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 66 | |
| 65 | |
| 30 | |
| 26 | |
| 25 |