Forum Discussion
Filter 2 tables without relation to each other
Hello,
I am new to Power BI and there is a problem that I just can't solve. There are two tables and I can't relate them to each other. The first table includes all archived orders. The second table contains all complayned orders. The columns of interest are the customer number and year. It is unfortunately so that in the table2 not always customer numbers are indicated. Also the year dates are never 100% correct because of year overlaps. So I can't link the tables via these two columns.
my goal:
Leave the tables without relation to each other so there is no Data lost.
A filter on my Power BI page which filters both tables independent by year and a filter for the customer. Right now this only works if I have two data slices with the filter for the year and two for the customer. I would like to have them combined. Also in the end i want to have a card that displays the Percentage of claimed to archived orders
My question:
Can I apply the filter I created over one column (year from table 1) also to the year from table 2 without relationship of the tables?
If yes how ?
If no how can I make the data filterable over customer as well as year ?
Do i have to combine the Data somehow ?
Thank you so much for helping!
Hi Anonymous ,
For this you need to create two separated tables (years and customers) that include the all the distinct values of both order tables then you make a relationship of one to many from the new tables to the order tables and you can filter out the tables using only a slicer for each (year and customer).
5 Replies
- MFelix
Super User
Hi Anonymous ,
For this you need to create two separated tables (years and customers) that include the all the distinct values of both order tables then you make a relationship of one to many from the new tables to the order tables and you can filter out the tables using only a slicer for each (year and customer).
Hello , I have a template table for filtering which contains the filter data and the fields I need to filter the report , the thing is I can't make a relationship because the filter changes everytime and I work with a lot of data , I can't seem to find something to make the filter happen without relating the 2 tables . Thanks a lot in advance for the help
- MFelix
Hi Anonymous ,
What do you mean by you have filter data and fieds by they are changing everytime?