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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
krypto6969
Helper I
Helper I

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 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. 

 

I added the same column in my query but that didn't work

Capture888999.JPG

 

How can I split out the same value into tow different slicers?

 

6 REPLIES 6
Sean
Community Champion
Community Champion

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 Smiley Happy - otherwise you'll need to create another table - Slicer Table

Sean
Community Champion
Community Champion

Here are the steps to creating the Slicer Table

 

Slicers External & Internal 1.png

 

and the result...

Slicers External & Internal 2.png

 

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

Slicers External & Internal 3.png

 

Hope this helps.

Good Luck! Smiley Happy

Hi Sean,

 

When I get to step two I see:

 

Capture2331.JPG

Sean
Community Champion
Community Champion

@krypto6969

 

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

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

Phil_Seamark
Employee
Employee

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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