Forum Discussion
Issues with relationships
If I understand you you want to filter both tables by the same date.
You need a third table, a Calendar Table that can have a relationship to both table 1 and table 2 on their date column.
You can find many resources on how to create a calendar table in power bi
Then when you filter on the date in the calendar table, it should filter both table 1 and table 2 to show records with that date.
Here's one helpful link https://kohera.be/blog/power-bi/how-to-create-a-date-table-in-power-bi-in-2-simple-steps/
Hi kentyler
I have try that already, but the problem is that if i take off the relationship between tables with the custome column that i've created, now im not able to filter by type, or even by region or sub region.
That's been my problem so far
Do you have one record only for each customer in each table ? You should be able to extract a table of customers, with one record for each customer and then create relationships between that and table 1 and table 2. If you don't want to filter for the same date in both tables you might need to have one calendar table for each of them.
Hi kentyler
No, is not 1 record per customer, there is actually around 500k rows but only around 200 buyer names, so there is alot of lines for the same buyer name, and that is my problem, that i cannot filter everything on the same page with 1 data, thats what i've been trying to do, but for some reason the relationship that im making is not working, and its for obvious reason a many to many relationship
Can you extract the distinct buyer names into a table. Then that table should be in a 1 to many relationship with both table 1 and table 2