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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

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