How to show detail tables only after selecting a row on main table in Power BI?

[Zhinee]

Hi all,
I'm working with Power BI and have a setup where:

• I have a main table called Session, which should show when initially loading the page.

• Each session contains many Joblets

What I want is:

• Initially, only the Session table is visible, the Joblet table should be hidden 

• When I click on a row in the Session table, then the Joblet table should appear and show the relevant data

Is this kind of interaction possible in Power BI? If so, how can I implement it?

Thanks!

[v-saisrao-msft]

Hi @Zhinee,

Have you had a chance to review the solution we shared by @danextian @lbendlin @Aburar_123 @techies ? If the issue persists, feel free to reply so we can help further.

Thank you.

[techies]

Hi @Zhinee happy to help setting up bookmarks, let me know

[Aburar_123]

Hi @Zhinee ,

Please try the below approach.

I have created two tables as below,

Created a relation based on Session column then create a measure as below,

Measure = IF(HASONEFILTER('Session Table'[Session]),1,0)

then, used the above Measure in the visual filter,

Joblet table will give you the data if you select any record in the session table.

[danextian · Accepted solution]

No out of the box solution but things you can do.

Drillthrough to another page (the simplest)

Page tooltip - no interaction with the visuals in the current page so scrolling up and down a table in the tooltip is not possible

Bookmarks - toggle the visibility of the joblets table with a click of a button.

[lbendlin]

Use the Drillthrough feature, or buttons to navigate to the Details page.

[MattAllington]

There's no out of the box solution, but you can use this work around

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/