The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have turned off the stepped layout for the matrix & added more fields to the row section. But I can't Horizontally scroll through the expanded rows section. It's like frozen. Is there any way to scroll that?This fields that i added to row section of matrix & turned off the stepped layout for this view but cant horizontally scroll through this, I need a view like this, Is there any work around?
Solved! Go to Solution.
Yes, if Stepped layout is turned on , you get as hierarchical order.
Attach a screenshot below for your reference:
If this is what you are looking , plz mark as solution and a thumps up
Hi,
Try this: right-click somewhere in the matrix (not the header) and select: Unfreeze row headers
Only thing is that if you close and open it will be undone again (also checked the .pbip files, no change is captured).
You can right-click on the matrix and there should be an option called "Unfreeze row headers".
Can just agree with @gcarvalho this was the best thing since sliced bread! Thanx @straightbasher !
After two years, 500 posts, hours in chat GPT... saw this simple answer that changed my life forever lol
Thanks @straightbasher
This was acctually a kind of neat work around. Not optimal but still.
(177) How To Make a Vertical / Horizontal Scroll Bar in Power BI Report - YouTube
Yes, if Stepped layout is turned on , you get as hierarchical order.
Attach a screenshot below for your reference:
If this is what you are looking , plz mark as solution and a thumps up
Not sure with your scenario unless we have a sample pbix file. May be your data is heavy , try publishing and use the visual in power bi service. The ram in your pc matters to load and scroll heavy data with measures which could be overridded by using them in power bi service
These all are the fields I added to the matrix. & turned off the stepped layout. (if it's not turned off the fields I added in the row section will be in a hierarchical order, that's not what i needed)
It's not more than the page size, I resized it, won't work. it's the row section thatis unable to scroll ,
I believe your visual size is more than page size. Resize the visual to fit in page and you could see horizontal scroll bar automatically added.
Kindly make as solution and thumps up. If still problem exist , attach a sample pbis file.
User | Count |
---|---|
78 | |
77 | |
37 | |
33 | |
31 |
User | Count |
---|---|
93 | |
81 | |
59 | |
49 | |
48 |