cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nirvana_moksh Established Member
Established Member

Matrix Visual Stepped Layout Out Off Error

Hello All,

 

So I have this matrix built in which I want the stepped layout off because each column I add I want it adjacent to one another rather than stepped out.  When I keep the stepped layout feature off I achieve what I want but after few additions of columns, the visual does not show any scrolling options. Is this expected behavior? Below is demo data's screenshot:

 

21.PNG      

 

 

 

221.PNG 

 

 

Thank You

4 REPLIES 4
Community Support Team
Community Support Team

Re: Matrix Visual Stepped Layout Out Off Error

Hi @nirvana_moksh

As tested, when you add many columns in the "Row" field of Matrix, it doesn't show scrolling options on the bottom of the matrix visual to let you navigate to the last columns.

When you add  many columns in the "Column" field of Matrix, it shows scrolling options on the bottom of the matrix visual to let you navigate to the last columns.

Based on my experience using Power BI, it seems not a bug.

 

Best Regards

Maggie 

Highlighted
nirvana_moksh Established Member
Established Member

Re: Matrix Visual Stepped Layout Out Off Error

So are you saying, it is expected behavior if we add too many columns in the "Rows" field that the scrollbar won't show, but it will allow us to add as many columns as we can? I would say that is a bug then, or am I missing something?

 

And adding these columns in the "Column" field does show the scrollbar which I had no issues with, but it does not give the results I want it to. For instance, all numerical columns in my dataset then have a column for each value which I don't want. The end result should be what I see when columns are added to the "Rows" fields.

 

 

columns.PNG

nirvana_moksh Established Member
Established Member

Re: Matrix Visual Stepped Layout Out Off Error

Hello @v-juanli-msft any update on my reply?

Community Support Team
Community Support Team

Re: Matrix Visual Stepped Layout Out Off Error

Hi @nirvana_moksh

If i understand you correctly, you'd like to add columns in the Matrix but keep "scrollbar" shown,

You could add columns in the "row" and "value" field of A matrix visual like this

1.png

 

Or add columns in the Table visual

2.png

 

Best Regards

Maggie

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 427 members 4,453 guests
Please welcome our newest community members: