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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
rrk92
Regular Visitor

Power Bi data table row actions

Hi,

Please help with this issue.

in power bi dashboard 

two data tables

Data table 1 view has four columns:

Job Id, source system, feed, platform

Data table 2 view has :

job id , job status , job start, job end

 

: when user selects a job id row from data table 1 then data from data table 2 rows should pop up if nothing selects from data table 1 , data table 2 should show empty or hide.

 

if you can help with this issue

thanks a lot in advance 

RK

 

1 REPLY 1
Sergii24
Super User
Super User

Hi @rrk92, you can obtain the desired result by writing this simple measure that will verify if table 1 is filtered. 

 

Table1 Filtered = IF( ISFILTERED( Table1 ), 1, 0 )

 

 
Then you can use this measure as a visual level filter and set it to 1 (so the visual will show data only when table1 is filtered):

Filter applied:

Sergii24_0-1713624065442.png

No filter:

Sergii24_1-1713624086743.png

I hope it will help you, have a great day!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.