How to split out same column into two slicers (with pic)

Question

HI,&nbsp;I have a value in my query called input user.&nbsp;&nbsp;Some of these users are internal and some are external. They are stored together in the database.&nbsp;In power BI im trying to figure out how to split these out into two slicers. So my end users can pick from either list and get what they want. I can't seem to be able to filter them out so that when u filter one it doesn't effec the other.&nbsp;&nbsp;I added the same column in my query but that didn't work&nbsp;How can I split out the same value into tow different slicers?&nbsp;

krypto6969 · Answer

Hi Sean,&nbsp;When I get to step two I see:&nbsp;

phil_seamark · Answer

Maybe try adding the column twice to your query.

The SQL might look like SELECT inputuser AS ExternalUser, inputuser AS InternalUser ........

Then you can two columns in your table that you can link to individual slicers.

sean · Answer

The easiest way to do this although you probably may not like it is with the Hierarchy SlicerWhere you can open either Internal or External and select!Give it a try&nbsp;:smileyhappy: - otherwise you'll need to create another table - Slicer Table