Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
joshua1990
Post Prodigy
Post Prodigy

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 model that is showing the budget for each product and is based on these 3 tables:

  • Fiscal Calendar
  • Master Data
  • Budget

Now, I would like to show on a bar chart the actual sales vs the budget.

It is not possible to rebiuld the first semantic model and to add the budget information.

Is this possible? If so, how?

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

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:

and this whitepaper:

Composite Models - SQLBI

 

Hopefully, this helps to tackle your challenge.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

1 REPLY 1
TomMartens
Super User
Super User

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:

and this whitepaper:

Composite Models - SQLBI

 

Hopefully, this helps to tackle your challenge.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors