Forum Discussion

bgreen's avatar
bgreen
Frequent Visitor
1 year ago
Solved

Clickable Terms for Definitions

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 sa...
  • Nasif_Azam's avatar
    1 year ago

    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