Forum Discussion

bacon6actual's avatar
bacon6actual
Frequent Visitor
10 years ago
Solved

Date Table Relationship to Multiple Fact Tables

I am still learning powerbi and I have trouble understanding the relationship results when dealing with multiple fact tables and one date deminsion. I work at a police department that runs a software...
BhaveshPatel's avatar
BhaveshPatel
Super User
10 years ago

Hi there,

 

Have you set up a correct data types? 

 

Regards,

Bhavesh

bacon6actual's avatar
bacon6actual
Frequent Visitor
10 years ago

Yes all data types are set correctly. Its seems pretty staright forward to me, but unlike other BI products its like powerbi does not like to let you filter by more then one deminsion. I do set one relationship to bi-directional the others cause issue and its says that only one filter is allowed. Doesnt make any since to me. I am used to crystal reports and sql. 

  • bacon6actual's avatar
    bacon6actual
    Frequent Visitor
    10 years ago

    Filtering two data tables from one date source should not be this difficult....lol.