Two Table join issue using third table

[RAKESH1986]

hi,

I have these two tables 10_early_pw_discipline and  30_late_pw_discipline

I want to create a dashboard by using both tables but want to filter graphs based on a column discipline.

below is the data in these two table:- 

10_EARLY_PW_DISCIPLINE

Discipline, EARLY_PW_WK, PW_EARLY_BASELINE

ELECTRICAL	PW01	0.03%
PIPING	PW01	0.02%
ELECTRICAL	PW02	0.05%
PIPING	PW02	0.05%
PIPING	PW03	0.07%
ELECTRICAL	PW03	0.08%

30_LATE_PW_DISCIPLINE

Discipline, Attribute, PW_LATE_BASELINE

ELECTRICAL	PW01	0.03%
ELECTRICAL	PW02	0.05%
ELECTRICAL	PW03	0.08%
PIPING	PW01	0.02%
PIPING	PW02	0.05%
PIPING	PW03	0.07%

I created the below graph its working fine but for this, I added a new table discipline and applied a filter.. so my query is why should I add a new table discipline and make join with both existing tables to achieve this.....how i can achieve this without adding a new table to make join?

[pratyashasamal]

Hi @RAKESH1986 ,
You can make the relationship between 10_EARLY_PW_DISCIPLINE and DISCIPLINE as bidirectional 
Note :- Please avoid having any relationship between 10_EARLY_PW_DISCIPLINE and 30_LATE_PW_DISCIPLINE . A circular relationship flow is not encourage in power bi .
Please refer to this link :- https://powerbiconsulting.com/cross-filter-power-bi/

Thanks ,
Pratyasha Samal 
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C