Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aaronmartin1651
New Member

Sales comparison between dates not updating

1.JPG

2.jpg3.jpg

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 group by hour so that I get hourly totals.  Then I linked that to a table that converts the 0-23 hour format to 12 hour format.  I also have one of the table linked to another table that converts the numerical department number to a readable format.  

 

 

 

 

 

 

 

 

 

 


My problem is that when I view the data and select various departments, only the data from the table that is linked to the department descriptions changes the other data stays the same.  I tried linking both tables to the Department table but it linked as a dotted line and did not seem to make any difference.  What am I missing?  How can I link the totals (black line) to adjust when the departments are selected?

1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

2 REPLIES 2
OwenAuger
Super User
Super User

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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Thank you that did the trick!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.