Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous 

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.