Forum Discussion
Query in Table relationship and Visual
- 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"
- 4 years ago
Anonymous
This should be bi-directional
Learn more >> https://docs.microsoft.com/en-us/power-bi/guidance/relationships-bidirectional-filtering
Thanks,
Ritesh
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"
waooo, it works !! this is something new to me !. thank you!!