Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
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...
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • MFelix's avatar
    MFelix
    3 years ago

    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).

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

Hi Anonymous ,

 

What do you mean by you have filter data and fieds by they are changing everytime?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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