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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
rrk92
New Member

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.