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

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

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
Community Champion
Community Champion

@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
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

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

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.