Forum Discussion
Filter multiple queries withour relationship
Hi ONCKdata,
You could create a third table to get the unique column Manufacture, then you can create the relationships with the tables.
1. Create the third table in Query Editor by Append Queries as new.
2. You could remove other columns and the Duplicate rows.
3.Create relationships among the tables like below.
4. Then you could create the Slicer with Manufacture in Append table.
For reference，you could have a look at my test pbix file which has been attached below.
Best Regards,
Cherry
Hi, thank you for the reply.
Sorry, I might have conufused you with misused terminology. (I have tried to correct the message)
I am attaching the sample file in below link.
As you can see, there are currently two different filters for manufacturer. I am looking for a solution to have common filter which can be applied to both graphs.
Hi ONCKdata,
You could create a third table to get the unique column Manufacture, then you can create the relationships with the tables.
1. Create the third table in Query Editor by Append Queries as new.
2. You could remove other columns and the Duplicate rows.
3.Create relationships among the tables like below.
4. Then you could create the Slicer with Manufacture in Append table.
For reference，you could have a look at my test pbix file which has been attached below.
Best Regards,
Cherry
This helped me fix my report. Thank you