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.
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!
Ok looks like a few people forgot this issue. But it was brought up in 2015 and still gets comments:
I willl try the workaround to see if we can live with it.
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.
Hey @Anonymous
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.
Hi @Anonymous ,
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI am able to see, what is the exact issue
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!!
@Anonymous
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |