data modeling

Hi misgirl_ny ,

To implement a many-to-many relationship in your data model in Power BI, you will need to use a bridge table. A bridge table is a table that contains the many-to-many relationship and links two other tables together.

- In your case, you can use the intermediate table with the combination of VisitID and DimID as the primary key as the bridge table. You can then create a relationship between the bridge table and the fact table on the VisitID column, and a relationship between the bridge table and the dimension table on the DimID column.

- To use the dimension table as a slicer and slice the fact table data, you will need to create a slicer visual in your Power BI report and select the dimension table as the slicer field. Then, you can use the slicer to filter the data in the fact table by selecting the desired values in the dimension table.

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.