Skip to main content

Power BI

New

Add Matrix Horizontal Scroll Bar

Vote (92) Share
Chris K's profile image

Chris K on 01 Jun 2016 20:05:30

The Matrix view needs a horizontal scroll bar just like the Table view. It appears at the bottom for large cross tabs but is not enabled and the data gets cut off, forcing me to switch to table view.

Comments (16)
Chris K's profile image Profile Picture

0e427567 ca41-44e7-bff9-557ff66ad165 on 05 Jul 2020 23:28:15

RE: Add Matrix Horizontal Scroll Bar

We need this feature to be added as soon as possible. The matrix table has great capabilities if it did not have this limitation. I do have the scroll bar included in the matrix but it only works on values and not rows. This set back is preventing different reports that I could create because the view is limited.

Chris K's profile image Profile Picture

7c5f8a03 b075-4820-aee0-9f963adf08d3 on 05 Jul 2020 22:48:03

RE: Add Matrix Horizontal Scroll Bar

This limitation y a great drawback, for example when showing tabular data for all the days in a year. I can show only columns for the firs four months. It' is right to think that can be solved filtering the columns, but not always can be solved that way and, anyway, it must be an election of the user who views the data, not a system limitation.

Chris K's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:47:36

RE: Add Matrix Horizontal Scroll Bar

I'm not convinced that concluded this to be 'by design' is really listening to the users with this one, as I feel this one is a pretty significant shortcoming for the matrix visual..? I find this to be a constant bugbear when many of my matrix visuals require large amounts of non-numeric/informational rows preceding the value fields, which pushes the values fields off the end of the available page space in the report (making the scroll bar impossible to use anyway!). Would it be possible to simply have TWO scroll bars at the bottom? One for the Values section, and another one for the preceding data/information section, which would visually appear a bit like a 'split screen' view in Excel?

Chris K's profile image Profile Picture

55674497 e1fe-447c-a750-34eb0ba40d7e on 05 Jul 2020 22:45:40

RE: Add Matrix Horizontal Scroll Bar

The horizontal scrollbar on the matrix is required, some of my users like the way the matrix presents the information but are unable to scroll across when a lot of columns are added on the matrix

Chris K's profile image Profile Picture

3f258fbd d604-4457-8f76-b6b02d4eb86a on 05 Jul 2020 22:35:19

RE: Add Matrix Horizontal Scroll Bar

Why such a limitation?

Chris K's profile image Profile Picture

c9368b8b d0fe-4854-9893-751ba6be08d8 on 05 Jul 2020 22:29:47

RE: Add Matrix Horizontal Scroll Bar

Hi Chris, horizontal bar only scrolls on numeric columns for the Matrix visual as per design. You would have to place all your non numeric columns to the left of the view, and all the numeric columns to the right in order to enable the horizontal scroll capability. Hope this helps. Please let us know if you have any further question on this.