How to filter a slicer based on selected table row?

[Zhinee]

I'm working on a Power BI report with two tables:

• A Session table visual

• A Joblet table visual (each session can have multiple joblets)

I added a slicer with Joblet name

What I want:

1. When a user clicks a row in the Session table,

2. The Joblet Name slicer should update to show only joblets linked to that session

But now the joblet name slicer is showing all the joblets. 
How can I limit it to only show the ones to the session row I clicked on?

[v-shamiliv]

Hi @Zhinee 
As per our previous conversation, we did not receive any response, so we are closing this thread. We would be happy to assist further in the future.
Thank you.

[v-shamiliv]

Hi @Zhinee 

I wanted to check if you had the opportunity to follow up on our previous conversation. If yes can you please provide the sample data so that we can provide you with the accurate and correct solution. 

Please feel free to contact us if you have any further questions. 

Thank you

[v-shamiliv · Accepted solution]

Hi @Zhinee 
Thank you for reaching out microsoft fabric community forum

Could you please provide some sample data so that we can assist you more efficiently?
Thank you.

[ryan_mayu]

@Zhinee 

pls provide some sample data and expected output.

[bhanu_gautam]

@Zhinee Verify that there is a relationship between the Session table and the Joblet table. Typically, this would be a one-to-many relationship where one session can have multiple joblets.

Add the Joblet Name field to the slicer visual.
Ensure that the slicer is set to interact with the Session table visual.

Click on the Session table visual to select it.
Go to the "Format" tab in the ribbon and select "Edit Interactions".
You will see interaction options for each visual on the report page. Ensure that the slicer visual has the filter icon (funnel) selected, indicating that it will be filtered based on the selection in the Session table.

Test the Interaction.

[Zhinee]

Yes, I have followed the steps you mentioned. 

But still does not work, 
After I click on a row on Session, nothing get applied to the joblet name slicer, so it still shows all the options.