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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Myrax7984
New Member

Adding Data from 2 different tables

Hello,

 

This is gonna be my 1st post asking for help in english since it's not my native langage.

 

I'm asking for help to create a report with mixed tables.

 

I got a pie chart i would like to decompose.

Pie chart.PNG

 

The "Multi Cause" field is based on a first table "Intervention[Commentaire_INT]"

This data can have many sense and i would like it to be more precise.

I created a table where the information are stored

 

multi.PNG

 

Instead of having the "Multi Cause" in the pie chart, i would like to have the values from the table in pic to be added to the pie chart.

 

Ex : The "Spare HS" field on the Pie Chart is : "28"

How could i add the "18" from the second table without having the "Multi Cause" showing on it ?

 

Thanks in advance for any help.

1 REPLY 1
PhilipTreacy
Super User
Super User

Hi @Myrax7984 

It's not really clear where all the data is coming from.  You said you have 2 tables but you only show some data for one of them.  Where's the data for the pie chart?

Can you please provide data from both tables - as files not pictures - so I can get a better understanding.

Thanks

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.