Forum Discussion
Solved
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...
Hi MStoib ,
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).
MFelix
Super User
Super UserHi Anonymous ,
What do you mean by you have filter data and fieds by they are changing everytime?
Hi thanks for your answer , i have a table to filter , and then there's a table with new values from my main table which is the filter table , and the filter table changes everytime depends on the demand of filtering