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...
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).
MFelix
Super User
Super UserHi 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).
Thank you so much!! it worked !