Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Visualization Table Grid Repopulates/Resorts when Record is Selected

‎10-07-2018 01:06 PM

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

Message 1 of 7
1,103 Views
0
1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft Employee
Microsoft Employee
In response to Anonymous

‎10-08-2018 02:19 AM

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.

Visualization_Table_Grid_Repopulates_Resorts_when_Record_is_Selected

 

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

Message 6 of 7
1,063 Views
0
6 REPLIES 6
parry2k
Super User
Super User

‎10-07-2018 01:28 PM

@@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.

Message 2 of 7
1,100 Views
0
Anonymous
Not applicable
In response to parry2k

‎10-07-2018 01:58 PM

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

Message 3 of 7
1,097 Views
0
parry2k
Super User
Super User
In response to Anonymous

‎10-07-2018 02:09 PM

@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.

Message 4 of 7
1,092 Views
0
Anonymous
Not applicable
In response to parry2k

‎10-07-2018 02:35 PM

@parry2k

 

I reproduced the issue using the AdventureWorksDW2012 database.

 

In the Picture, I select Product in chart. Table grid shows correct values.In the Picture, I select Product in chart. Table grid shows correct values.Getting Ready to select record Brittany Price.Getting Ready to select record Brittany Price.After I select record, grid resorts to Aaron Hughes and the whole grid is dimmed out.After I select record, grid resorts to Aaron Hughes and the whole grid is dimmed out.

Message 5 of 7
1,088 Views
0
v-jiascu-msft
Microsoft Employee
Microsoft Employee
In response to Anonymous

‎10-08-2018 02:19 AM

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.

Visualization_Table_Grid_Repopulates_Resorts_when_Record_is_Selected

 

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.
Message 6 of 7
1,064 Views
0
Anonymous
Not applicable
In response to v-jiascu-msft

‎10-08-2018 03:30 AM

@v-jiascu-msft

 

Perfect, Just what I was looking for!

Message 7 of 7
1,059 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

View All