Forum Discussion
Query in Table relationship and Visual
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
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
This should be bi-directional
Learn more >> https://docs.microsoft.com/en-us/power-bi/guidance/relationships-bidirectional-filtering
Thanks,
Ritesh
6 Replies
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
This should be bi-directional
Learn more >> https://docs.microsoft.com/en-us/power-bi/guidance/relationships-bidirectional-filtering
Thanks,
Ritesh
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
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.