Forum Discussion

byronholloway's avatar
byronholloway
Regular Visitor
6 years ago

Slicer Picklist Contains multiple Values

I have a fairly large dataset (25K records)  with a fairly straightforward dataset:

We use these generally to priortize how we make sales calls.  We want to call on manufaturers and designer.  

Account     Industry                               other data

aa Corp     Audio/Video;Electronics

BB Corp     Contract Manufacturer

CC Corp     Distirbutor - Audio Video

DD Corp     Electric Supply

EE Corp      Robotics;Battery;UAV

FF Corp      Oil & Gas - Wireline;MRO

 

All in all there are 125 categories.   I am trying to filter by industry, but Robotics;Battery is a different selection from Robotics;MRO and Robotics;Game\Consumer.     I tried to use the example contained here:

https://community.powerbi.com/t5/Desktop/Dynamic-filtering-slicing-if-text-contains/m-p/425504#M195756

but I could not make it work on my dataset.   

Ideally I would like to import a list of data set values and have it filter for "contains exactly"  (so it can discriminate between "Audio/Video" and "Distributor Audio/Video" )  I would also like to figure out how to exclude values like "MRO"   
Can someone point me in the right direction ?    

 

Thanks

Sincerely, 

Byron Holloway