three table join include a date table

[Anonymous]

Hi

I have a question about joinning three tables toghther or just built relationship among them

I have a date table and other two tables

I use the date table as fact table and join on the other two tables' date column as picture  shows

then I want to visualize the report in this way as show

I use "date" from date table as slicer and list the information in the table at the bottom of picture

the information looks good, but I cannot add the date columns from query2 table in this table

otherwise, it cannot display

I know it is because Query1 and Query2 table has no relationship, 

but I have jioned them to date table, so I cannot build other relationship between these two tables since Power BI only allow to join with one table

Do you know a way to join the three table toghther or can list all columns from Query1 and Query2 in one Power BI with accurate records and no display issue?

Thanks

[v-yulgu-msft]

Hi @Anonymous,

Please drag date field from date calendar table into visual.

Regards,

Yuliana Gu