Clickable Terms for Definitions

[bgreen]

I had a Power BI report and it has a list of terms and it was a drill through, so when you clicked on it a second table would filter to the definition. It was requested that this happen within the same table. Of course the behavior is that the it highlights the term and definition. But the key requirement is that it's 'clickable'. This seems vexing because if they found they term they have also now found the definition. I believe the functionality they want is when a term is selected all other terms and definitions vanish with the exception of the one selected. Accomplishing this with two tables takes about thirty seconds and it's the functionality I had. But within the same table, that is where I am lost. This is the same behavior as using a slicer, but this is not the requested functionality. In short, click on term in a table and all other selections vanish. I think this functionality isn't possible, as indicted by attached visual, or is painfully simple and I promise I did research this before asking the forum. Thank you in advance for your time. 

[Nasif_Azam]

Hey @bgreen ,
Currently Power BI does not currently support making text within a single table act as a clickable filter that hides all other rows within the same visual. You havealready implemented the best available solution: using two visuals one for selecting the term and another to show the filtered definition. This mimics a “click-to-show” behavior effectively and remains user-friendly.

What You Can Do Further:

• Two-table setup (as you originally had): Still the most straightforward and user-friendly solution. One table (terms) acts as a filter for the second (definitions).

• Use of bookmarks or slicers: Can simulate the “only show selected” effect, but they require external controls and do not provide the same intuitive click behavior within a table.

• Field Parameters (if using them): Only switch columns, not rows or row visibility based on clicks.

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam

[lbendlin]

Best you can get is a visual distinction of the "selected"  item - the unselected items become more transparent. However, you cannot control that level of transparency.

Push back on the requirement, make them embrace the hover.