- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
pls see the attachment below
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks for the file this is what i needed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
pls see the attachment below
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks you a lot😁
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you are welcome
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ok I see. This is what i tried first but i wanted the output like a table.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-10-2024 11:18 PM | |||
05-01-2024 03:13 AM | |||
04-22-2024 10:40 AM | |||
06-14-2024 09:34 AM | |||
06-28-2024 07:24 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |