Forum Discussion
Hide rows in table based on user selection
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?
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.