cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DataUPBI Frequent Visitor
Frequent Visitor

Multiple Rows in Matrix Visualizations Power BI

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

2 REPLIES 2
itchyeyeballs Established Member
Established Member

Re: Multiple Rows in Matrix Visualizations Power BI

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

Community Support Team
Community Support Team

Re: Multiple Rows in Matrix Visualizations Power BI

Hi DataUPBI,

 

Could you share some sample data and clarify more details about your requirement?

 

Regards,

Jimmy Tao