admin管理员组

文章数量:1421700

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.

Share Improve this question asked Jan 17 at 18:40 not_a_generic_usernot_a_generic_user 2,1983 gold badges23 silver badges40 bronze badges
Add a comment  | 

1 Answer 1

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)

本文标签: Why do fields still show in PowerBI when I have them filtered in the modelStack Overflow