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. 

[bgreen]

Thank you, to your point they had the functionality they wanted, but the insistance of having it in one table utterly halted my ablity to give them what they wanted. A case of tell me what you want, but not how to deliver it. Thank you again. 

[v-hashadapu]

Hi @bgreen , Thank you for reaching out to the Microsoft Community Forum.

No, Power BI still doesn’t support clicking a row in a table to filter and show only that row within the same visual. Clicking highlights the row and can filter other visuals, but the table itself can’t dynamically hide the rest. Your original two-table setup, where one table filters the other is still the best native solution.

If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[bgreen]

Thank you so much, I was worried I was missing the obvious, thank you for your time. 

[Nasif_Azam · Accepted solution]

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

[bgreen]

I appreciate the work around, thank you. 

[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.