Forum Discussion
Applying a filter to two different SharePoint lists
My apologies for the delayed response (family emergency).
What I was trying to do was find a way that one (common) filter could work on two separate lists displayed in a Power BI report. They shared common data but even establishing a relationship between the columns that had identical data failed to allow a single filter to work on both lists.
It turns out I figured out the solution myself by using UNION to create a new table using the "common" columns, establishing a relationship between each list column and the combined (new) table, then using THAT table as a filter.
This process allows me to enter ONE data variable then it calls up all rows in both lists that have that common variable.
Hi Anonymous ,
I'm not sure if I understand your needs accurately.
Have you tried to extract the data from SharePoint List and process the conversion in Power query?
Merge the columns of data and then filter them？
Please see if the following article is helpful to you：
Sharepoint List Extracted Data
Shape and combine data in Power BI Desktop
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
My apologies for the delayed response (family emergency).
What I was trying to do was find a way that one (common) filter could work on two separate lists displayed in a Power BI report. They shared common data but even establishing a relationship between the columns that had identical data failed to allow a single filter to work on both lists.
It turns out I figured out the solution myself by using UNION to create a new table using the "common" columns, establishing a relationship between each list column and the combined (new) table, then using THAT table as a filter.
This process allows me to enter ONE data variable then it calls up all rows in both lists that have that common variable.