Filtering a table

[Flyn]

Hello,

I have this table. 

Letter	Number
A	1
A	2
A	3
B	1
B	2
B	3
C	1
C	2
C	4
D	4
D	5
D	6
D	7
E	2
E	3

If i put a slicer on the number, and choose the number {1,2}, how can i do to have the letter with only 1 and 2 combined. like below. not the letter = to 1 or 2 but that = to 1and2 only

Letter

A

B

C

Thanks for reading

[ryan_mayu · Accepted solution]

@Flyn 

pls see the attachment below

[Ashish_Mathur]

Hi,

PBI file attached.

Hope this helps.

[Flyn · Accepted solution]

thanks for the file this is what  i needed

[ryan_mayu · Accepted solution]

@Flyn 

pls see the attachment below

[Flyn]

thanks you a lot😁

[ryan_mayu]

you are welcome

[d_rohlfs]

Hi @Flyn, 
Because you are trying to slice on a table, you cannot summarize your 'Table'[Letter] column while the 'Table'[Number] column is in the same table. But, if the 'Table'[Number] column is not present in the table you should get your desired result. 
If this is not acceptable, you could try doing some DAX with a Concatenate() function, but this gets a lot more complicated. 

[Flyn]

Ok I see. This is what i tried first but i wanted the output like a table.