How to filter graph to show only X-Axis values only where Y-Axis is equal to the legend?

[pauliduplooy]

I have the following stacked bar chart with the shown visualization settings:

Is there a way to show only the X-Axis values where the legend is the same as the Y-Axis?

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[pauliduplooy]

Below is the sanitized sample data. The data is in two different tables and there is a relationship between the identifier columns in the two tables.

Table 1:

Source 1	Identifier	OVIDs	OVIDs Affected
IWI	673648294	0000627e-47b1-42a3-80c4-540a0fd1c84e	3
RDR	0	0005a75d-a7ae-43ef-a2f5-d8dced82c4c0	3998
RDM	TBC	0006b772-07ed-4f42-a986-3d98f02d8f07	102
iMeta	3219	000bcbbb-0ac0-490f-a16d-d4dc44702439	3
SLU	3219	000bcbbb-0ac0-490f-a16d-d4dc44702439	3
RDR	0	001073d2-e711-4ce1-8c99-7b2c46087fdc	3998
CCM	hdje1293	0010cc40-905a-49c6-9820-6401db860d9a	4
IWI	1hd829482s	00114ad5-5182-43b1-a4f3-bc1bf4e3bb89	38
iMeta	339499	001325a8-d5e2-4b21-8014-ce510016a679	3

Table 2:

Identifier	Count of Identifier	Source 2
ZC000018	1	RDR
ZC000018	4	iMeta
ZC000018	5	SLU
Z3113349	1	RDR
YA4610132	1	RDR
XXX	1	RDM
XXX	1	RDM
X123	2	SLU
X4931426	1	RDM