Forum Discussion
Filtering a table
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
thanks for the file this is what i needed
7 Replies
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.Ok I see. This is what i tried first but i wanted the output like a table.
Hi,
PBI file attached.
Hope this helps.
thanks for the file this is what i needed
