Hey guys, hope you are doing fine and could help me with an issue that I dont understand.
I have 3 excel tables which I hae uploaded on Power BI (3 different tables, therfore 3 different queries)
My goal is to use it for analysis gathering different information from different sources to create a robust dashboard about the status of deliveries (Information are spread out in different excel files so I want to gather then).
What I have done so far:
1. Uploaded the tables
2. Created a key in each excel table in order to have an unique number to create the relationship
Key: Sales Document + material row + Material name
The issue is that it seems the relationship is done but when I create 3 tables in the dashboard they don't seem to filter the information of the others....For example below there are 3 tables from the 3 different files
But when I click in one of them the others remain the same instead of fitlering the information in the others (filtered highlighted in yellow)
So before keep developing this dashboard I need to know how to make then work at same time so when someone want to consult one Sales document let's say then the other info will be automatically shown in the other tables. Relationshps seems to be working accordingly to the table below: