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