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.
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
Solved! Go to Solution.
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
@@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.
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.
Kind Regards,
Kelly
@Anonymous not sure what is going on. Is it possible to do a screen grab of your action to show what is going on
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.
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
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |