Forum Discussion
Solved
Combine 2 Datasets in 1 Chart
Hi experts! I have 1 semantic model that shows the actual sales for each product for each data. The model is based on 3 tables: Fiscal Calendar Master Data Sales Then I have a second semantic ...
Hey joshua1990 ,
you have to create a composite model from both semantic models, read this article: Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Next I also recommend reading these articles:
- New composite models in Power BI: A milestone in Business Intelligence - SQLBI
- Understanding the interactions between composite models and calculation groups - SQLBI
and this whitepaper:
Hopefully, this helps to tackle your challenge.
Regards,
Tom
Hey joshua1990 ,
you have to create a composite model from both semantic models, read this article: Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Next I also recommend reading these articles:
- New composite models in Power BI: A milestone in Business Intelligence - SQLBI
- Understanding the interactions between composite models and calculation groups - SQLBI
and this whitepaper:
Hopefully, this helps to tackle your challenge.
Regards,
Tom