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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
fyoung
Frequent Visitor

filter based on one column of a visual but how to show all relevant data from original data table

I have some sample data like this:

SEQUENCE_NBRCASE_IDSTATEDEVICE_IDDEVICE_TYPECAUSE_OF_TROUBLETOTAL_CUSTOMERSACTUAL_MINUTESEVENT_TIMEUPDATE_DEPTAPPROVED_BYAPPROVED_DATE
85058661304508354A1391665TFV41804/1/19 9:08 AM                     NULL
85058671304508354A1391665TFV41804/1/19 9:08 AMNETWORK              NULL
85067151304512698A4051751393OPP345094/1/19 10:45 AM                     NULL
85067161304512698A4051751393OPM345094/1/19 10:45 AMNETWORK             WILLI4/3/19 7:59
85067091304515661A372F            LFH1018504/1/19 12:17 PM                     NULL
85067101304515661A372F            LFH1018204/1/19 12:17 PMNETWORK             WILLI4/3/19 7:58
85067071304528795A695515TFM11474/2/19 6:32 AM                     NULL
85067081304528795A695515TFS11474/2/19 6:32 AMNETWORK             WILLI4/3/19 7:57
85067051304532851B1456T           LFM2242024/2/19 9:34 AM                     NULL
85067061304532851B1456T           LFS2204/2/19 9:34 AMNETWORK             WILLI4/3/19 7:57
85067031304536185B422311TFM2124/2/19 11:24 AM                     NULL
85067041304536185B422311TFS204/2/19 11:24 AMNETWORK             WILLI4/3/19 7:57

 

I have a few slicers and show a brief table after slicer applied:

main table.JPG

Now in another more detailed table, what I want to show is if I click the first case_id "1304541261"in the above table, I would it to show all rows in the original table which has case_id "1304541261", not only just that one row.

So this is what I want:

want.JPG

However this is what I get:

not want.JPG

 

Any suggestion? Sample Data and pbix file are uploaded here. Thanks!

1 REPLY 1
v-juanli-msft
Community Support
Community Support

Hi @fyoung 

When selecting one row of the table, it should only show that row by design.

I am working to find a workaround and will give another post when i complete it.

 

Best Regards
Maggie

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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