How to divide column values into horizontal values

[adiletsh]

Hello everyone 

I need to get visual element like this:

To do this I have 2 columns with values:
1)before the bracket "БП2", "БП1" and in bracket 
2) in bracket 
 
first column  values:

second column values:

So, The working principle of two columns is : "БП1" may have 12 numbers in second column but it doesn't work in the opposite direction. Unique quantity of first column values 12 its From "БП1" To "БП12". Every first column values have ("БП1") have 12 numbers in second column.

Selected date filters two columns and I will get that values in visual element in a table form.

So,  my problem is to do this visual element.


Thank you in advance.

[ryan_mayu · Accepted solution]

@adiletsh 

is this what you want?

Measure = CONCATENATEX(distinct('Table'[column2]),'Table'[column2],",")

pls see the attachment below

[ryan_mayu · Accepted solution]

@adiletsh 

is this what you want?

Measure = CONCATENATEX(distinct('Table'[column2]),'Table'[column2],",")

pls see the attachment below

[adiletsh]

Thank you for you answear, this is partly correct. But I need to do this visual element in Card visualization

[ryan_mayu · Accepted solution]

@adiletsh 

is this what you want?

pls see the attachment below