Forum Discussion
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...
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.
