cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aaronmartin1651 Frequent Visitor
Frequent Visitor

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

Accepted Solutions
OwenAuger Super Contributor
Super Contributor

Re: Sales comparison between dates not updating

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
OwenAuger Super Contributor
Super Contributor

Re: Sales comparison between dates not updating

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

aaronmartin1651 Frequent Visitor
Frequent Visitor

Re: Sales comparison between dates not updating

Thank you that did the trick!

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 203 members 2,315 guests
Please welcome our newest community members: