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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
DiKi-I
Post Partisan
Post Partisan

Hide rows in table based on user selection

Hi All,
I need help in implementing one of the solution asked by my client. 
I have a table in my report and I want to give user a check box/delete button against each row. When the user clicks on that button that row should hide from the table view. Could you please help me on how this can be achieved?

6 REPLIES 6
DiKi-I
Post Partisan
Post Partisan

Hi ,
I have a report page which shows list of new legal enity which has been added in the source side. Once a legal enity is added the user needs to go and update a mapping file with detail so that sales data can be pulled from the source.
So the report page shows some legal entity that's new, some legal enities are irrelevent and they really wouldn't like to see in that report page. They need the option in the powerbi report so that they can remove it from the table view.
Let me know if it explains better or you have any question.

@DiKi-I 
why you dont create a column that differenciate between the rows that should be deleted ( 2 values ; to keep , to remove )

and the rows that should remain in the visual . Then you add this column in the filter pane --> filter on this page, and you filter the column on the value --> to keep 

 

 

let me know id that helps

 

Thanks Daniel. I can do this but how I can give user the fliexibilty to choose so that they can decide if they want to keep it or remove it?

@DiKi-I 

then instead of making it a fixed filter in the filter pane - filter on page, you can creat a slicer containing this column. 

thus the use can either selected to see all data, or the rows to keep  or the rows deleted.

the column value 2 values (to keep , to remove) , how this will be set? This is dynamic and will be determined by user. I don't have the flexibility to set this values in the table.

Daniel29195
Super User
Super User

@DiKi-I 

correc my if im wrong. you want a column in your table visual, having like a delete / checkbox button , that if the user click on that button ( per row ) ., wil hide the row selected in the table view .

 

 

i dont think that this is possible .

 

 

can you explain the value of such thing ? maybe i can help you find an alternative solution for this .

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.