How to view related data with single click (no Ctrl+Click)?

[Zhinee]

I have 3 table visuals :

1. Session

2. Joblets ( 1 session to many joblets )

3. Joblet Detail (1 joblet to many joblet details)

Current flow:

• User clicks a row in session table, joblet and joblet details for that session are displayed.

• Then the user has to Ctrl + Click a row in the joblet table to load the joblet detail for that joblet.

Users find the Ctrl + Click interaction unintuitive and strongly dislike using the ctrl+click.  

Is there a way to make this work?

[v-tejrama]

Hi @Zhinee,

Thanks for reaching out to the Microsoft fabric community forum.

If you're trying to avoid using Ctrl+Click to filter across visuals like from Session → Joblets → Joblet Details, here's a simple fix:

Just use Edit Interactions from the Format ribbon.
Click on your Session visual → go to Format > Edit Interactions → make sure the filter icon is active on the related visuals Joblets and Joblet Details.

Now, when you click a row in Session, it will automatically filter the related visuals no Ctrl key needed.

Also, double-check if multi-select with Ctrl is turned off in the visual settings.That way, it behaves like a clean single-click filter.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Best Regards,
Tejaswi.
Community Support Team

[danextian]

I am assuming you're using a bookmark to display further details. If the user is consuming the report from a pbix and not from a published copy in the service then Ctrl + click is necessary. After all, Power BI Desktop is meant for development.

[Zhinee]

No I am not using bookmarks.

I am using 3 table visuals, and the issue appear in power bi service not desktop. 

[Irwan]

hello @Zhinee 

i might be misunderstood, but i assumed this is about value selection.

i think you only need ctrl+click if you are in PBI desktop.

if the visual has already been published, it should only need click.

Thank you.

[Zhinee]

On table A, user do just need to do click 
But table B will shows related records after user click on table A
Then now if user want to select a row at table b,
They have to do a CTRL+CLICK 
so that they can see the result for table C.

[danextian]

It seems that you are trying crossfilter table C using the data points from A and B. Ctrl + click is necessary to click multiple data points especially in different visuals. Not doing so deselects the previous selection. 

[Zhinee]

Is there a work around for this?
Users did not accept using the CTRL + click.
( I dont have to use 3 tables, but I do need to show joblet details based on what is selected in session records and joblet records) 

[v-tejrama · Accepted solution]

HI @Zhinee ,

Add Two Slicer Visuals

• One slicer for Session ID / Name

• One slicer for Joblet ID / Name

Users can select a Session → Joblets are automatically filtered
Then select a Joblet → Joblet Details show automatically
(Just make sure relationships exist properly in the model)

 Use Edit Interactions

• Click on the Session slicer → Format → Edit Interactions

• Ensure it filters both the Joblet slicer and Joblet Details table

• Repeat for Joblet slicer → make sure it filters Joblet Details table

This avoids the need to click visuals. You guide users with slicers, not tables.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Best Regards,
Tejaswi.
Community Support Team