This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. 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...
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 39 | |
| 24 | |
| 22 | |
| 20 |