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
DarylRob
Helper I
Helper I

Slicer that only shows user names in the other table

Hi, 

 

So I have two tables, one is my primary table RESULTS that is solely used for the report and this has "OwnerID" in it and then I have a USER table which i'm pulling the users name based on the OwnerID

When I create a slicer on Name from the USER table it gives me all names, not just those that are in the RESULTS table, how can I just show those names with an OwnerID in the RESULTS table..

 

Cheers, 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @DarylRob,

Currently, you can’t directly do this on your slicer. I'd like to suggest writing a measure formula and use on a slicer to achieve filter records.

formula =
VAR userList =
    ALLSELECTED ( Table2[UserName] )
RETURN
    IF ( SELECTEDVALUE ( Table1[UserName] ) IN userList, "Y", "N" )

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

Hi @DarylRob,

Currently, you can’t directly do this on your slicer. I'd like to suggest writing a measure formula and use on a slicer to achieve filter records.

formula =
VAR userList =
    ALLSELECTED ( Table2[UserName] )
RETURN
    IF ( SELECTEDVALUE ( Table1[UserName] ) IN userList, "Y", "N" )

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
VIJAYKUMART
Resolver I
Resolver I

hi.. provide some sample data and exact column names u have and  it is more clear expected output is mentioned

truptis
Community Champion
Community Champion

@DarylRob -> Did it work? 

truptis
Community Champion
Community Champion

Hi @DarylRob ,
You can put a filter on your visual which says OwnerID from USERS table is "Not Blank"
Steps: 
1- Select your visual and drag and drop the OwnerID field in the filters pane.
2- Select Advanced filtering and select is not blank option
3- Click on Apply

@DarylRob  Please accept it as a solution if this helps you. Thank you.
Regards,
TruptiS

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.