Solved: Visualization Table Grid Repopulates/Resorts when ...

Anonymous · ‎10-07-2018

Hello,

I have an important project I am working on. I am building a Power BI report. I have a Pie Chart and a Grid. The pie chart contains all the Products and the time working on these products. When I select a product on the pie chart, the grid populates with only the records that go with that product as it is suppose to do. The problem is when I click on a row in the table grid, the data in the grid repopulates/re-sorts instead of just highlighting the selected row(record). How can I prevent this repoplating of the data in the grid when I select a particular record?

Kind Regards,

Kelly

v-jiascu-msft · ‎10-08-2018

Hi @Anonymous,

That's the expected results. The highlight status can't be kept all the time. But you can keep the status by using "CTRL" + mouse click. You can give it a try.

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

parry2k · ‎10-07-2018

@@Anonymous

not sure which visual you are using for grid? Are you using table/matrix visual? When you select a row in a table/matrix, expected behaviour is that it will highlight the row in grid and filter the pie chart. Not sure why it repopulating/sorting etc, please provide more details

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.

Anonymous · ‎10-07-2018

Hello @parry2k,

I am using the table visual. If I select a product (Product A) on the pie chart, the table then shows all the records for Product A, which it is suppose to do. Then when I select a row in the table grid for one of the records associated with Product A, it repopulates/resorts the table and the table actually becomes faded (greyed out) until I reclick on the pie chart. Any idea what is causing this? I don't want the table to behave like this.