Single Slicer for shared dimensions across multiple Power BI datasets?

Hi MahmoudZou ,

Thanks for the clarification.

Just to add to what parry2k mentioned, this is expected with the current composite model behavior. Even if the business semantic models originate from the same shared dimensions dataset, Power BI still treats each semantic model as a separate source group. Because of that, the dimension tables do not automatically merge and the relationships defined inside the source models are not inherited when multiple semantic models are combined in one report.

As you noted, loading only the fact tables would require rebuilding relationships in the Balanced Scorecard, which defeats the purpose of reusing the existing logic. At the moment there is no supported feature that recognises two dimension tables from different semantic models as the same table and keeps a single slicer without extra modeling.

For more details, please visit:
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Composite model guidance in Power BI Desktop - Power BI | Microsoft Learn

There are similar community threads discussing this scenario:
Solved: Composite model relationships / shared dimension t... - Microsoft Fabric Community
Shared Dataset and Composite Dataset - Microsoft Fabric Community

One practical approach is to create a single semantic model that contains the shared dimensions once and then connects to the business facts. The Balanced Scorecard would then rely on that single model instead of combining multiple semantic models at the report layer, avoiding repeated relationship work.

You can monitor the Power BI release plans and Fabric blog for any future changes in this area.

Hope this helps. Please reach out for further assistance.

Thank you.