Forum Discussion

krypto6969's avatar
krypto6969
Icon for Helper II rankHelper II
9 years ago

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

HI,   I have a value in my query called input user.    Some of these users are internal and some are external. They are stored together in the database.   In power BI im trying to figure out ho...
Need Help
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

The easiest way to do this although you probably may not like it is with the Hierarchy Slicer

Where you can open either Internal or External and select!

Give it a try :smileyhappy: - otherwise you'll need to create another table - Slicer Table

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

Here are the steps to creating the Slicer Table

 

 

and the result...

 

You can also probably duplicate the Columns User Name and User Type in your table and then...

 

Hope this helps.

Good Luck! :smileyhappy:

  • krypto6969's avatar
    krypto6969
    Icon for Helper II rankHelper II
    9 years ago

    Hi Sean,

     

    When I get to step two I see:

     

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      9 years ago

      krypto6969

       

      My table was actually called Table, In your case looking at the picture = Query1

      • krypto6969's avatar
        krypto6969
        Icon for Helper II rankHelper II
        9 years ago

        Hi Sean,

         

        I followed your steps-I think the disconnect (my fault) is that the internal user list and my external list are the same users. 

         

        I need to manully define our internal users from a list, then the rest are all external.

         

        Will your method of using the split table still work - maybe I'm missing somthineg