How to get multiple values in the same table to point back to on "key" in the same table in Power BI

[JacobMich]

I have a table similar to below in PowerBI.  Originally I was linking relationship between SC and another table.  We have since added more places and now I need Level 1 to include 100,118, and Q.  My visual bar graphs I just want them to show Level 1-5 without adding extra spots for Level 1 - 100 (Bar Graph). 118 (Bar Graph), and Q (Bar Graph).  It shows 3 for Level 1 instead of a combined one bar in the visual for "Level 1".  The values in SC, NC, GA, NC, and CA have multiple instances in another table.

Level	SC	NC	GA	NC	CA
1	100	118			Q
2	101	111			P
3	102	112			O
4	103	113			N
5	104	114

[srlabhe]

Your ask is bit difficult to understand , kindly provide intended O/p with sample PBIX if possible

[JacobMich]

This is the original table.  When I create a Bar Graph Visual, 1 has 3 graphs (108,118,Q), 2 has 3 Graphs (101,111,P) and so forth.  How do I get my visual for "1" to combine the 108,118,Q data.

Levels	Code
1	108
2	101
3	102
4	103
5	104
1	118
2	111
3	112
4	113
5	114
1	Q
2	P
3	O
4	N

[Ashish_Mathur · Accepted solution]

Hi,

Create this calculated column formula

All codes=CALCULATE(CONCATENATEX(Data,Data[Code],", "),FILTER(Data,Data[Levels]=EARLIER(Data[Levels])))

Use this new column on the X-axis.

[srlabhe]

share the PBIX please 

[JacobMich]

Apologies, I can not because of privacy.  Thanks