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...
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.

    • bacon6actual's avatar
      bacon6actual
      Frequent Visitor
      10 years ago

      thank you very much for shedding some light on this. Your help is very much appreciated.

      • Barath's avatar
        Barath
        New Member
        9 years ago

        Hi bacon6actual,

         

        I am too experiencing the same problem:(  By any chance did you get a solution for this issue of yours?

         

        Thanks in advance

         

         

        Regards,

        Barry