Data Modeling multiple value bridge tables

Hi jswartz_09,

Thank you for clarifying. When you try to include columns from Employment, Work Orders, and Work Completion in one visual, Power BI can’t determine a single filter path because these tables are linked through a many-to-many bridge. Unlike SQL joins, Power BI visuals rely on relationships and filter propagation, so multiple many-to-many paths cause ambiguity that prevents all columns from displaying correctly.

If you need to show columns from each table side by side, the best approach is to flatten the data in Power Query by merging the tables (like your SQL join) or create a summarized reporting table that combines only the needed fields. These options give you a single, unambiguous table for visuals. If you prefer to keep your current model structure, measures like TREATAS can still work for calculations, but visuals showing columns from all tables will require a combined dataset.

Refer these links:
1. https://learn.microsoft.com/en-us/power-query/merge-queries-overview 
2. https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9 

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.