Forum Discussion
Filter different record in one column
Hey all, I am trying to create a new filter for my dashboard. There is a column inwhich one entity can have multiple types. So in power query I created a table inwhich every entity's type is in a...
So the solution was to refresh the table and it worked. But for furture readers. You have to create an extra table where you create a row for each search option for a record. For example apple has the release column P2 (P3). Here you create 2 rows where there are an apple P2 and apple P3. Then you create a relationship between these 2 tables and now you can use them as filters.
Or maybe if you how to create a filter which would work like in excel. If the record contains it then it would show up.