Stop Matrix Scrolling When Selecting Row Label

twebb · ‎01-07-2021

Hello!

I've got two matrices and I'm having trouble with scrolling in one of them.

Matrix A has product numbers. Matrix B has stores and product numbers. Each is several hundred rows and they contain different info so I can't just combine them into a single matrix.

When I select a product number in matrix A, matrix B filters to show the stores that offer the product. If I then select a store in the newly filtered matrix B (removing the product number filter) because I'd like to see all products offered in that store, the matrix will unfilter and gray out all other stores (which is fine) but then the visual seems to scroll to some random spot so I lose my place and have to try to find it again. Is there any way to stop this so I don't lost my place every time?

Thanks!

parry2k · ‎01-07-2021

@twebb I think you should put this as an idea on the ideas forum, not sure if there is any solution for this.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

twebb · ‎01-07-2021

Good idea! I'll do so now. I'm sure it will end up being low on the priority list but maybe one day!

Stop Matrix Scrolling When Selecting Row Label

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly