cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bmjmm3624 Occasional Visitor
Occasional Visitor

Matrix not allowing horizontal scroll in Power BI Desktop or Online (IE11, Chrome, etc.)

With a cross tab matrix that has a lot of row fields, the matrix has a horizontal scroll bar enabled, but for some reason the scroll does not function in either the Desktop or Online tools.

10 REPLIES 10
Moderator WillT
Moderator

Re: Matrix not allowing horizontal scroll in Power BI Desktop or Online (IE11, Chrome, etc.)

Hey - when you have enough row groups in a matrix so that they don't all fit in the viewport, the scroll bars are disabled. This is because scrolling normally only affects the values area of the matrix. If you've got lots of text data, try using a table instead? Hope that helps Will
AJB New Member
New Member

Re: Matrix not allowing horizontal scroll in Power BI Desktop or Online (IE11, Chrome, etc.)

I encounter the same issue..

By choosing a table, the problem is partially fixed: horizontal scrolling works, but the visual representation of the info/data is clearly different.

Drobinson1 Member
Member

Re: Matrix not allowing horizontal scroll in Power BI Desktop or Online (IE11, Chrome, etc.)

I have many data points in the rows for product charterstics that we need to display.  I cannot scroll to see the data.  It would be nice to choose where to freeze the view.

B_Real Regular Visitor
Regular Visitor

Re: Matrix not allowing horizontal scroll in Power BI Desktop or Online (IE11, Chrome, etc.)

+1 experiencing this problem.

 

Vertical scrolling works in a matrix, but horizontal does not. 

 

"when you have enough row groups in a matrix so that they don't all fit in the viewport, the scroll bars are disabled. This is because scrolling normally only affects the values area of the matrix."


Not sure what this means. Why would you disable scroll bars if your data doesn't fit in the viewport? The entire purpose of scroll bars is to show data that doesn't fit in the viewport. 

 

Showing the data as a table does remedy the scrolling problem, but it's an unsightly way of presenting data that has repeating values in a column. 

jwjwjwjwjw Regular Visitor
Regular Visitor

Re: Matrix not allowing horizontal scroll in Power BI Desktop or Online (IE11, Chrome, etc.)

Agreed, not sure what the upside of not allowing this would be. The matrix display is so much better, but the ability to scroll horizontally is vital. Why even create it if you are going to leave out such an obivous feature. Please fix ASAP, there are so many of these formatting quirks out there that might seem trivial to a software designer but can absolutely ruin a project. Spending hours trying to google a workaround is not an efficient use of my time. 

 

The point about choosing a default location on a scrollbar is also a must implement. 

B_Real Regular Visitor
Regular Visitor

Re: Matrix not allowing horizontal scroll in Power BI Desktop or Online (IE11, Chrome, etc.)

I think we figured out what's happening. It looks like Power BI is treating the matrix 'rows' like 'freeze panes' in Excel. I.e. all the variables you put into the 'rows' (which actually become columns in your matrix, but lets not go there for now) are fixed and not scrollable because they are frozen. If you put variables into the 'values' part of the matrix, these then become scrollable

 

But only the 'values' will be scrollable, not the rows (which are frozen). 

 

This is a shame. In my line of work (healthcare) we frequently use many columns of categorical data for statistical analysis, and its pretty crucial to be able to see your data in column format. Categorical data doesn't really work in the 'values' section of the matrix visualisation. 

 

 EDIT - I think this description actually echo's what WillT says above. The terminologies used are really confusing (for me anyway). Microsoft call the columns in a matrix 'rows', and 'values' are also columns but they appear to the right off all the other columns ("rows"). 

Matladi1 Frequent Visitor
Frequent Visitor

Re: Matrix not allowing horizontal scroll in Power BI Desktop or Online (IE11, Chrome, etc.)

Hi Family, Is there a work around for this? I really need to use the Matrix NOT Table andd I have quite number of columns. 

Highlighted
perezmarcone Regular Visitor
Regular Visitor

Re: Matrix not allowing horizontal scroll in Power BI Desktop or Online (IE11, Chrome, etc.)

Microsoft Still has not fixed this? this happened to me today.

pallavishrivas Occasional Visitor
Occasional Visitor

Re: Matrix not allowing horizontal scroll in Power BI Desktop or Online (IE11, Chrome, etc.)

Hi Everyone,

I am also facing it, no resolution from microsoft yet.

Guys pls help.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 207 members 2,244 guests
Please welcome our newest community members: