Forum Discussion
Solved
How do I link two data fields that aren't foreign keys to synchronize filtering?
Let's say I have two tables that look like this: Sales: Id LocationId Amount($) DateOfTransaction YearNumber MonthNumber DayNumber 1 42 12345.67 2012-10-22 2012 10 22 2 42 ...
- You should make a separate date table that you can link both fact tables to. Then use the year-month field from the date table for the axis in your two charts.
dkay84_PowerBI
Microsoft Employee
Microsoft EmployeeYou should make a separate date table that you can link both fact tables to. Then use the year-month field from the date table for the axis in your two charts.
I was afraid that was the answer but I think you're right. Thanks!