Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
9024gnsd
Regular Visitor

Table Visual - Prevent unfiltering on row click

I have a report with a pie chart and a table.  Selecting a slice of the pie chart filters the table as expected.  However, even with interactions disabled from the table, when I click on any record in the filtered table, all filters are reset resulting in all table records being shown. 

 

Is there any way to prevent this from happening?    The current behavior causes me to lose my place and have to re-apply filters.  The reason I care about clicking on a table row is because I'm using the dataSelected event to trigger an exteral application via Power BI embedded.

12 REPLIES 12
Mouza
New Member

Hello,

Hope you are doing well and safe

could you please let us know if are able to find the solution for this issue.

bgunzenhauser
New Member

Did anyone ever find a solution outside of the "invisible card layer" trick?

Anonymous
Not applicable

I'm running into the same cumbersome issue. As you have said, it can be avoided pressing Ctrl+Click, but users of this report won't do this, I'm sure, so the only workaround I have found is setting an invisible card layer above the table to prevent users from clicking on it. Is is planned to work on this issue?

 

Regards.

9024gnsd
Regular Visitor

Thanks for the reply. Ctrl-click does preserve the position but does not trigger the data selected event so it’s just a partial solution. I think this may just be a limitation of Power BI and additional functionality is needed to preserve filters on table clicks.
witaing
Microsoft Employee
Microsoft Employee

I ran into the exact same issue and I'm surprised this hasn't been more significant of a complaint before. I have the table filtered perfectly down to how I want it, but then when I click on a row it messes everything up. Even when I have all interactions with other visuals turned off. 

Im having the same issue and i also think it is a significant Issue, what can we do to amplify the message? How are people getting beyond this problem?

The only workaround right now is to hold ctrl while you click 😕 

I posted a similar question https://community.powerbi.com/t5/Desktop/Table-filter-resetting-when-table-row-selected/m-p/699528/h... and got the same not very helpful response of clicking ctrl.  Its fine if you know this, but users using the report...

v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @9024gnsd,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @9024gnsd,

Based on my test, you could use the Ctrl+Click to locate your filtered data.

Reference:https://docs.microsoft.com/en-us/power-bi/desktop-multi-select

 

Regards,

Daniel He

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

Of course this was not solved. Quite anoying. Using CTRL key is not a solution as users don't know this and this is actually allowing users to select multiple records in the table. Replacing the table with a slicer is not a solution as users cant see other useful attributes. If clicking on a table should reset the abobve selections as it is happening now, then the table visual should include an option to not reset the selection from the other visuals, while an user is clicking on the table. Otherwise this "feature" of reseting the selection can be considered as a bug as no interaction was set from the table visual to remove the selection from another visual.

Lexx
Frequent Visitor

I have had a similar issue,
2 table visuals
tbl_test1 and tbl_test2
tbl_test1 filters -> tbl_test2
when clicking on a row in tbl_test2 it resets the filters (very annoying)
My partial solution was to create a measure that takes the SELECTEDVALUE() from tbl_test1 and do an IF statement comparison and if result is true it is 1 and false is 0

 

 

IF(VALUES(tbl_test2[Column1]) = [selected_value]),
1,
0)

 

 

Since we are in a measure, the context is column so you have to protect the IF statement by surrounding it in another IF statement
to check if there is more than 1 value returned.
The full expression is

 

 

Measure = IF(COUNTROWS(VALUES( tbl_test2[Column1] ))=1,
IF(VALUES( tbl_test2[Column1] ) = [selected_value] ,
1 ,
0 ),
2 )

 

 

So when I click on a row in tbl_test1 the matching rows in tbl_test2 get a 1 and the rest 0.
This works well.

Since slicers do preserve the filter I figured I could just set a slicer to the Measure column in tbl_test2 and make the default value 1 and then hide the slicer.

But... you can't set a slicer to a measure column because of course why would you want to do such a silly thing.

So this is simply not something that Power bi is capable of sadly.

In the end I just set a slicer next to table 2 and based on the results from table 1 the end user
can make a selection in the slicer to see the data they want.

Kind of dumb, but the only way.

Lex

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.