Reply
Flyn
Frequent Visitor

Filtering a table

Hello,

 

I have this table. 

LetterNumber
A1
A2
A3
B1
B2
B3
C1
C2
C4
D4
D5
D6
D7
E2
E3

 

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

2 ACCEPTED SOLUTIONS
ryan_mayu
Super User
Super User

@Flyn 

pls see the attachment below

11.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

thanks for the file this is what  i needed

View solution in original post

7 REPLIES 7
Ashish_Mathur
Super User
Super User

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1728528522723.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

thanks for the file this is what  i needed

ryan_mayu
Super User
Super User

@Flyn 

pls see the attachment below

11.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




thanks you a lot😁

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




d_rohlfs
Resolver I
Resolver I

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
Frequent Visitor

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)