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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
andrsnjhnstn
Frequent Visitor

Can I create a slicer that has 2 selections, but data has 3 categories? (slice A,B,C by A,B or A,C)

Hi there,

 

I have data than can be categorized as A, B or C and I need a slicer that has two selections: 

Selection 1: A,B

Selection 2: A,C

 

Example Data:

ItemsCategory
ShoesA
BalloonA
AppleB
CarC

 

Slicer Selection 1: A,B

= Shoes, Balloon, Apple

 

Slicer Selection 2: A,C

= Shoes, Balloon, Car

 

Any tips or guidance is appreciated!

 

Thanks

2 REPLIES 2
Anonymous
Not applicable

Hi @andrsnjhnstn ,

I don't quite understand what you mean. Can't you just multi-select in slicer? What do you mean by two choices in slicer? Can you provide more info on this?

 

vrongtiepmsft_0-1694052769368.png

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

MURTAZA
Resolver I
Resolver I

How about applying visual level filters?
Just select the slicer and on the filter pane, just select the categories you would like the slicer to show. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.