cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adanecito
Post Patron
Post Patron

No horizontal scroll for Matrix visual?

Hi All,

Is horizontal scrolling available for the Matrix visual? I noticed if I add columns that go beyond the visible area no horizontal scroll bar appears. I am using the Febuary 2020 release.

 

Thanks!

10 REPLIES 10
adanecito
Post Patron
Post Patron

Ok looks like a few people forgot this issue. But it was brought up in 2015 and still gets comments:

https://community.powerbi.com/t5/Desktop/Matrix-not-allowing-horizontal-scroll-in-Power-BI-Desktop-o...

 

I willl try the workaround to see if we can live with it.

 

adanecito
Post Patron
Post Patron

Okay I did some more testing and the horizontal scrollbar only shows up when a column is added to the "Column" for the "values". So I ran a simple test where I added one column from my fields and one row to my values. If I resize my matrix control so the column is not showing a scrollbar is added. If I move my only column to rows no scrollbar is show when I resize the matrix again.

 

I may have to add a blank narrow column to values to get the horizontal scrollbar.

 

I hope this helps others.

Tad17
Solution Sage
Solution Sage

Hey @adanecito 

 

I know there was an old bug that had this happen when there were only text values in the matrix or no row headers. You can try converting to a table to see if the scroll bar appears. If no scroll bar appears for the table then you either need to reinstall Power BI Desktop or share a screenshot of your visual so we can further assess the problem. If all of your columns are visible in the window then there is no need for a scroll bar and it will not appear.

 

If this helps please kudo.

If this solves your problem please accept it as a solution.

I switched it to a table and the horizontal scrollbar showed up. I switched it back and the problem came back. I also noticed if I reduced the size of the visual to where a horizontal scroll bar should have appeared it did not. I also noticed if added a column to where the column should have been added to the rows instead it was added  coulmns and just that column would scroll with the new horizontal scroll bar. Really strange and still not solve the problem because half of the column would show and that would scroll inside the column if that make sense.

 

Again thanks for the reply.

MFelix
Super User
Super User

Hi @adanecito ,

 

As in the vertical if you add several columns that surpass the horizontal size of the matrix you will see the scroll bar available.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



I am able to see, what is the exact issue

Screenshot 2020-03-02 22.35.25.png



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Hi Amit,

I know this is an old post, but the issue still persists. I see that you have one field in ROWS and Multiple fields in VALUES. In this case, the horizontal scrollbar works. Alternatively, when you have just many fields in ROWS and only a single field in VALUES, the horizontal scrollbar doesn't work thought the scrollbar is available. The reason what I observe is that there is a column freeze till the end of the fields in rows. In other words, the scrollbar only works where you have multiple fields in ROWS.

Regards,

Vijay

Yep I repeated it the same way but no scrollbar..  So is this a bug? If so do you know if there is a workaround?

 

Thanks!!

@adanecito 

 

Can you share your a screenshot of your visual or share the pbix? normally this is only an issue if you do not have anything in rows or if there exists certain combinations of formatting.

I wish I could it is financial data and quite sensitive. The vertical scroll works fine and I have a combination of text and number columns.

 

I will see if I can replicate with other data.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors