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

Share Improve this question Follow asked Jan 17 at 18:40 not_a_generic_usernot_a_generic_user 2,19833 gold badges2323 silver badges4040 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 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)