Query in Table relationship and Visual

[Anonymous]

Hello Guys, hope you are well.

I have face one difficulties that would like to request for your kind assitance. 

Based on the screenshot below, the both supplier performance table have a dependency towards the calender table. 

However, when i created a visual. (X axis= "Date" from calendar, Y axis = column from supplier performance table, secondary y axis = from another supplier performance table). 

if appear something as below. does not show a relationship beweetn both supplier performance and calender table

[jdbuchanan71 · Accepted solution]

@Anonymous 

Filters flow in the direction of the arrow along the relationship so the fitler on the calendar table can flow down to the invoice data but it cannot flow back "up" (against the arrow) to the supplier so it does not get sent down to the Supplier Performance tables.  
You can make this relationship bi-directional so that the invoice data table can filter the supplier table.

If you right click on the line you can set the fitler direction to "Both"

[jdbuchanan71]

@Anonymous 

Put a year slicer on your report so you can see if it is data from a different year.  If you are showing just month name, January - 2021 and January - 2022 are both just January so you might be getting multiple years together.

[ribisht17 · Accepted solution]

@Anonymous 

This should be bi-directional

Learn more >> https://docs.microsoft.com/en-us/power-bi/guidance/relationships-bidirectional-filtering

Thanks,

Ritesh

[Anonymous]

hi @ribisht17 

Thanks for replying but i found out there is one issues i have encounter. 

I have change the relationship to bi-directional, 

I have created a chart as below using (X axis= "Date" from calendar, Y axis = column from supplier performance table, secondary y axis = from another supplier performance table).

But this issue is that, i dont have data from January to May in both supplier performance dataset. however, the chart is showing there is data from Jan to May 

[Anonymous]

thank you so much for your help!!

[jdbuchanan71 · Accepted solution]

@Anonymous 

Filters flow in the direction of the arrow along the relationship so the fitler on the calendar table can flow down to the invoice data but it cannot flow back "up" (against the arrow) to the supplier so it does not get sent down to the Supplier Performance tables.  
You can make this relationship bi-directional so that the invoice data table can filter the supplier table.

If you right click on the line you can set the fitler direction to "Both"

[Anonymous]

waooo, it works !! this is something new to me !. thank you!!