Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Date Bridge Table

Hi All,   I using visuals on same page from two different data sources. Neither have a primary key and thew date field is non unique. But I need both sets of visuals to change from the same date sl...
Need Help
GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi Anonymous

 

Can you try changing the Cross Filter direction to single on both relationships?


The Cross Filter direction set to BOTH can affect the other tables.

 

Also how did you go about creating your dCalendar table? I would suggest creating an independant table. I do have a blog post explaining how to do this: https://gqbi.wordpress.com/2016/09/13/power-bi-how-to-easily-create-dynamic-date-tabledimension-with-fiscal-attributes-using-power-query/