Forum Discussion
Post PatronSimultaneously filtering on separate Tables?
Hi F_Reh
Yes this is exactly what Power BI relational model is designed for. As long as your three tables share a common key like Client Number and are connected via relationship in Model view then filtering on Client Number in a slicer or filter will propagate across all related tables
Structure to use - you can set up star schema with one dimension table have unique Client Number records with one-to-many relationship connected to fact table.
On the SQL side - Instead of one large joined query you can import each table through SQL views like SELECT * FROM Clients, SELECT * FROM Orders, SELECT * FROM Transactions if you need all the columns for reporting then build the relationships in Power BI's Model view using Client Number as the key
Super UserHi F_Reh
Yes this is exactly what Power BI relational model is designed for. As long as your three tables share a common key like Client Number and are connected via relationship in Model view then filtering on Client Number in a slicer or filter will propagate across all related tables
Structure to use - you can set up star schema with one dimension table have unique Client Number records with one-to-many relationship connected to fact table.
On the SQL side - Instead of one large joined query you can import each table through SQL views like SELECT * FROM Clients, SELECT * FROM Orders, SELECT * FROM Transactions if you need all the columns for reporting then build the relationships in Power BI's Model view using Client Number as the key