Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have some sample data like this:
SEQUENCE_NBR | CASE_ID | STATE | DEVICE_ID | DEVICE_TYPE | CAUSE_OF_TROUBLE | TOTAL_CUSTOMERS | ACTUAL_MINUTES | EVENT_TIME | UPDATE_DEPT | APPROVED_BY | APPROVED_DATE |
8505866 | 1304508354 | A | 1391665 | TF | V | 4 | 180 | 4/1/19 9:08 AM | NULL | ||
8505867 | 1304508354 | A | 1391665 | TF | V | 4 | 180 | 4/1/19 9:08 AM | NETWORK | NULL | |
8506715 | 1304512698 | A | 4051751393 | OP | P | 3 | 4509 | 4/1/19 10:45 AM | NULL | ||
8506716 | 1304512698 | A | 4051751393 | OP | M | 3 | 4509 | 4/1/19 10:45 AM | NETWORK | WILLI | 4/3/19 7:59 |
8506709 | 1304515661 | A | 372F | LF | H | 10 | 1850 | 4/1/19 12:17 PM | NULL | ||
8506710 | 1304515661 | A | 372F | LF | H | 10 | 1820 | 4/1/19 12:17 PM | NETWORK | WILLI | 4/3/19 7:58 |
8506707 | 1304528795 | A | 695515 | TF | M | 1 | 147 | 4/2/19 6:32 AM | NULL | ||
8506708 | 1304528795 | A | 695515 | TF | S | 1 | 147 | 4/2/19 6:32 AM | NETWORK | WILLI | 4/3/19 7:57 |
8506705 | 1304532851 | B | 1456T | LF | M | 22 | 4202 | 4/2/19 9:34 AM | NULL | ||
8506706 | 1304532851 | B | 1456T | LF | S | 22 | 0 | 4/2/19 9:34 AM | NETWORK | WILLI | 4/3/19 7:57 |
8506703 | 1304536185 | B | 422311 | TF | M | 2 | 12 | 4/2/19 11:24 AM | NULL | ||
8506704 | 1304536185 | B | 422311 | TF | S | 2 | 0 | 4/2/19 11:24 AM | NETWORK | WILLI | 4/3/19 7:57 |
I have a few slicers and show a brief table after slicer applied:
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:
However this is what I get:
Any suggestion? Sample Data and pbix file are uploaded here. Thanks!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |