Forum Discussion

Jason6's avatar
Jason6
Helper I
6 years ago
Solved

Filter second table based on selected value in first table . No relationship exists between two tabl

Thank you in advance for your inputs I have two tables in my powerbi model , first which is the raw table and the second table which has items listed "Item"column from Table 1 is the slicer value w...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Jason6 ,

     

    You could edit your second table in query editor. Here is my sample data.

    1. Split "Column1" by delimiter. 

    2. Unpivot your category columns and remove extra columns. Now you could create relationships between two tables.

    Then you could use SELECTEDVALUE() function to get a result as a flag in filter pane.

    Here is my test file four your reference.

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Jason6 ,

 

You could edit your second table in query editor. Here is my sample data.

1. Split "Column1" by delimiter. 

2. Unpivot your category columns and remove extra columns. Now you could create relationships between two tables.

Then you could use SELECTEDVALUE() function to get a result as a flag in filter pane.

Here is my test file four your reference.

 

Jason6's avatar
Jason6
Helper I
6 years ago

Thank you everyone for your inputs . Greatly appreciate your help

v-eachen-msft I was able to achieve the result with your inputs, Thank you 🙂