Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    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's avatar
    Anonymous
    Not applicable
    4 years ago

    thank you so much for your help!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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