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.
Sean
Community Champion
Community ChampionWhen you enable drill down on one chart all interactions with other charts are disabled!
Why don't you plot both Actual and Projected in the same bar chart? (At least I think that's what you are trying to do)
and you can drill down and see both amounts in the same chart
Good Luck! :smileyhappy:
Hi Sean,
I can't put them in the same chart because the dates are in different tables. I would reall love to be able to do that but it doesn't seem to be an option given how the data is structured.
- dkay84_PowerBI
Microsoft Employee
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.I was afraid that was the answer but I think you're right. Thanks!