Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
nirvana_moksh
Impactful Individual
Impactful Individual

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
v-juanli-msft
Community Support
Community Support

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 

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

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

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.