Filter different record in one column

[motyotyotyo]

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 different line. After using relationships I was able to connect the table on the dashboard and the table which has every entities different type. For some reason some of the times this works, but sometimes not. One of the issue is that the filter is on but the dashboard doesn't change to that part or filter works in the dashboard, but the table which is for the filter has more options if I search for myself.

Any ideas are more than welcomed,

Thank you

[v-yangliu-msft]

Hi  @motyotyotyo ,

You can use Slicer in Power BI.

Slicers in Power BI - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[motyotyotyo]

Hi @v-yangliu-msft 

Unfortunately it is not good, as I have 2 information in one column. For example I have this record : P2 (P3) .

And I want this record to show up in P2 search and P3 search as well. I have created a table where there is list of record which P-s have it.

[motyotyotyo · Accepted solution]

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.

[motyotyotyo]

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.