Is it possible to create a pie chart between two tables

[SelflearningBi]

I am new to power bi still on learning path. I would like to create a pie chart between two of my table.  
Table 1:  Contains all of my Products  
Table 2: Only Contains Impacted Products and look like following table: with reason, ,weeks of delay being impacted and so on. 

I would like to create pie of pie chart look like this:  ( Or smiliar) 

On time % is from Table 1 (total quantity)
Other% is from table2 (impact quantity)

and those other covid impact, t2 material is from table 2 the reason( impact quanitty by reason) 

I try this,, but dont think it right. 

[Hariharan_R]

Hi,

it would be good if you share some sample data from both the table. There are different approaches. You can see below approach using calculated column in main product table.

Sample PBIX file - PowerBICommunity/Help.pbix at main · rhariharaneee/PowerBICommunity (github.com)

Thanks

Hari

[SelflearningBi]

@Hariharan_R 
Thank for helping, but what if i dont have 1 to 1 relationship ? 
I have also posted similar dataset that im using. 
I would also later to create slicers by using Name, S/O and supplier name, BU, and calcualte the differenct between this table：% of quantity being impact 

is it possible to do cross table calcualtion like this: Order Quantity - Impact Quantity  and the impacted %? 

Order Table 1

Name	BU	Supplier Name	Factory Name	Model Number	S/O	Order Quantity
Jack	APP	A	KK	11	IDE	10
FIFI	FW	A	KK	11	IDE	5
Amy	APP	A	C	12	ICH	2
Amy	APP	B	B	13	IPP	10
Amy	FW	B	B	14	IDE	10
Amy	APP	C	KK	66	IDE	10
Amy	APP	C	KK	89	IDE	10
Amy	HW	D	D	12	ICC	10
Amy	APP	C	KK	66	IDE	10
Jack	FW	C	KK	89	IDE	10
Jack	APP	D	D	12	ICC	10
Jack	APP	G	GG	10	IDE	10
Jack	FW	G	GG	1	IDE	10
FIFI	APP	G	GG	1	ICC	10
FIFI	APP	G	KK	15	IDE	10
FIFI	FW	F	O	17	IDE	10

Delay Table 2

Name	BU	Supplier Name	Factory Name	Model Number	S/O	Impact Quantity	Solution	Reason	Week of delay	Impacted Qty
Jack	APP	A	KK	11	IDE	10	GOOD	COVID IMPACT	1 WEEK	3
FIFI	FW	A	KK	11	IDE	5	GOOD	MATERIAL	2 WEEK	3
Amy	APP	A	C	12	ICH	2	GOOD	COVID IMPACT	3 WEEK	1
Amy	APP	B	B	13	IPP	10	GOOD	MATERIAL	2 WEEK	3
Amy	FW	B	B	14	IDE	10	GOOD	MATERIAL	1 WEEK	3
Amy	APP	C	KK	66	IDE	10	GOOD	COVID IMPACT	1 WEEK	4
Amy	APP	C	KK	89	IDE	10	BAD	MATERIAL	2 WEEK	4
Amy	HW	D	D	12	ICC	10	BAD	COVID IMPACT	4

[Hariharan_R]

Hi,

You can concatenate the first 6 columns to make a distinct values on both the tables and can build a relationship between the tables. Check the cardinatlity on the relationship. You can use RELATED or RELATEDTABLE DAX functions get the values from one table to another as a calculated columns. You also can acheive through DAX using the relationship between the tables.

Thanks

Hari

[SelflearningBi]

@Hariharan_R 

Hi, and coudl you show me how to do this?  the dark blue color is from table 1 master and others is from table 2. Not sure how to do it 

[Hariharan_R]

Hi,

You need to have one calculated column created in the main table where you have all products. using the "RELATED" function. This column should have the required value for the visual.

Thanks

Hari

[SelflearningBi]

@Hariharan_R Hi,
I did concatanate both my table, I still get many to many relationship, so I distanct my concatnate table, it turns into one to many, but i cant use the RELATED function now. 

[Anonymous]

Hi @SelflearningBi,

If the related function does not work for your scenario, you can also try to directly use the Dax function to extract the current value and use it as a condition to lookup other tables to get corresponding field values.

Introducing LOOKUPVALUE - SQLBI
Regards,

Xiaoxin Sheng

[Dhacd]

Good Day @SelflearningBi ,
This can be achieved by drillthrough page in powerbi.
I can attach screenshots on how to do this if requires. 

Thanks and regards,

Atma.

[SelflearningBi]

@Dhacd yes, could you please attach the scresshot how to do do this, many thanks.

[Dhacd]

You need to create a drill-through page. which means the add another page and then adding the reasons visual to that page. And in the drill through section add the measure you have used in the first visual and filter it for other reasons.

 you can right-click to the first visual(on other reason area of the pie chart) and click on drill through .you will be redirected to this page