Forum Discussion
Power bi report filter
I have a power bi report that contains three different tables. A,B, and C. i have a common column for all tables (ID) by using ID from table A i need to filter B,and C but B need to filter C as well....
rajendraongole1
Super User
Super UserHi Mahizee - Yes, you can achieve this in Power BI Desktop and Report Builder using relationships and possibly bidirectional filtering.
Avoid circular dependencies. If setting bidirectional filtering creates a circular relationship, consider using DAX measures or Calculated Columns as an alternative.
Test thoroughly with slicers and visual interactions to ensure the filtering works as expected.