Forum Discussion
Click On Single Row Of Table To Focus On All Related Instances In Same Table
Given a table:
| NAME | ID |
| A | 1 |
| B | 2 |
| A | 1 |
| C | 3 |
Is it possible to have a user click on a row of the table and have it isolate/focus on all related instances of that row per some value, in this case either by NAME or ID?
If I created another table or slicer of distinct values, for example:
| NAME |
| A |
| B |
| C |
and clicked on A, it would show the original table as such:
| A | 1 |
| A | 1 |
What I would like is to click on a row of NAME A on the original table without having another slicer or table to control it, and have it focus on all instances of that like this:
| NAME | ID |
| A | 1 |
| B | 2 |
| A | 1 |
| C | 3 |
Is this possible? Any creative workarounds? Thanks.
Hi Anonymous ,
Since duplicate rows could not be all shown in Table visual by design. Please go to Power Query and Add a Index column firstly to make each row different:
Then if you do not want slicer or filter, please try Drill-through and Page-level Tooltip:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- parry2k
Super User
Anonymous is this what you are looking for?
Unfortunately that is exactly the opposite of what I was asking for. My prompt especially just before the last table example, explicitly stated without the use of an external slicer, filter, table, etc. What I want is the experience to happen on one table. If the table had two rows of A, by clicking one I would like it to bold/isolate all 2 rows of A. Thank you.
Hi Anonymous ,
Since duplicate rows could not be all shown in Table visual by design. Please go to Power Query and Add a Index column firstly to make each row different:
Then if you do not want slicer or filter, please try Drill-through and Page-level Tooltip:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
