Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Nathan_9_
Regular Visitor

Slice table in power bi by multiple values in one column

Hey all,

 

Is it possible to slice/filter a table in power bi with multiple values from the same column.

Example

PersonAwards
A1
A4
A5
A7
A8
B2
B3
B4
C2

Above is similar to the data I have, I'm trying to filter a table that has 'person' with a slicer that has the awards. However I'm trying to filter with multiple awards (multi-select) and it is giving the wrong values. For example I am slicing awards 2 and 4 and the table is giving me person A, B, and C. What I want it to do is filter the person that has both award 2 and 4, which should give only person B.

 

If I could get any help on this that would be great.

Let me know if you need any more information.

 

Thanks

Nathan

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

5 REPLIES 5
Ahmedx
Super User
Super User

pls try this

Screenshot_1.png

Hey,

 

Thank you for your help this has worked amazing.

 

I have came across a slight propblem, becasue of the filter 'flag' on the table it seems I can't slice the table with any other data. 

 

Is there a way around this?

 

Thanks 

Nathan

what do you mean, I don't understand

explain in detail

I have 2 slicers one is the awards slicer and the other for example is a location slicer, but the location slicer can't filter the Person and Awards table. Is there a way to allow the Location slicer and any other slicers I may have filter the Person and Awards table?

post an example so I can help you
and show the expected result

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors