Forum Discussion
Solved
Filtering a table using values in a separate table and wild character
Dear community, I need your help. I have a Table_A containing 2 columns: - ID - Description I have a Table_B containing one column: - Lookup And I'd like to filter the rows in Table_A...
I think I found a solution in this article:
Hope this can be of any help to other users as well
A.
You may want to look at this blog post as it is a similar data structure. https://marqueeinsights.com/how-to-work-with-sharepoint-multi-value-columns-in-power-bi/
What you don't have is a cross-reference between Table A and Table B. The post shows you how to easily do this and set up the relationships so that you can filter as described.
Hope this helps!
--Treb, Power BI MVP
Check out our Power BI blog posts at https://marqueeinsights.com/category/power-bi/