Forum Discussion

aaronmartin1651's avatar
aaronmartin1651
New Member
9 years ago
Solved

Sales comparison between dates not updating

I have two tables generated by a MySQL query.  They are identical queries except for the date selected (yesterday's date and one year ago yesterday).  I transform the time column to g...
Need Help
  • OwenAuger's avatar
    OwenAuger
    9 years ago

    Hi aaronmartin1651

     

    I suggest you change the Cross Filter Direction for all your relationships to Single (currently they are all set to Both with the <> visible on each relationship).

     

    Then you should be able to create Active relationships between each of your fact tables to WFdata departments and Hour, and use those two tables for filtering.

     

    I can't see any need to have bi-directional relationships.

     

    By having all your relationships filtering both directions, you were ending up with a loop around the tables which isn't allowed, so Power BI was forcing one relationship to be inactive (dotted line).

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
9 years ago

Hi aaronmartin1651

 

I suggest you change the Cross Filter Direction for all your relationships to Single (currently they are all set to Both with the <> visible on each relationship).

 

Then you should be able to create Active relationships between each of your fact tables to WFdata departments and Hour, and use those two tables for filtering.

 

I can't see any need to have bi-directional relationships.

 

By having all your relationships filtering both directions, you were ending up with a loop around the tables which isn't allowed, so Power BI was forcing one relationship to be inactive (dotted line).