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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
DiKi-I
Helper V
Helper V

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
Helper V
Helper V

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
May PBI 25 Carousel

Power BI Monthly Update - May 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

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