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?
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