Filter out data based on a column value

[Anonymous]

I have a table called District and inside that table is a column named "Status", what I want to happen is that if a certain row has "DELETED" as its value in the Status column, I want my power bi visualizations to exclude all the data associated with that row including its relationships. How do I achieve this?

Will the filter pane exclude everything or do I need to use DAX?

Any help would be greatly appreciated!

[amitchandak · Accepted solution]

@Anonymous , One option is to filter in Power query and save, It will not come to Data model post that.

The second is add a report/all page level filter