My source data is full of data I don't need so I filtered them in my model in particular making sure none of the tags have the prefix CI: or AG:

Yet, when I create a table showing these values, I see rows that include data that should have been filtered away:

Why?

My process was to create a table "card" then click the values I wanted to include on the right:

I thought data I filtered in my model wouldn't be available to my report.

My source data is full of data I don't need so I filtered them in my model in particular making sure none of the tags have the prefix CI: or AG:

Yet, when I create a table showing these values, I see rows that include data that should have been filtered away:

Why?

My process was to create a table "card" then click the values I wanted to include on the right:

I thought data I filtered in my model wouldn't be available to my report.

• powerbi

1 Answer 1

Filters you apply in Table view have no effect on your model. They are just a convenience for you to view data in that view. To filter these values out, you should do so in Power Query (Transform Data)