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

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