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 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
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.
4 Replies
Hi Anonymous ,
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.
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.