Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Help Needed - How do I add clickable items embedded into a table visual?

Hello Experts,    I have a requirement where a user would like to use a single click on a column in a table to view a seperate logging table for the record. In screenshot 1 below we have the main r...
Need Help
parry2k's avatar
parry2k
Super User
5 years ago

Anonymous it can be easily achieved. Read this post about how you can hide the visual if no value is selected, in this blog post slicer has been used but the same solution can be applied if you using table visual. Show or Hide a Power BI Visual Based on Selection - Excelerator BI

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello parry2k and experts,

     

    I have implemented the solution suggested in the article and it is working really well. The issue that I am facing now is that I am attempting to overlay the "base table" with the "logging" table. As you can see in the screenshots, when a LKUP_ID is selected, we are showing the correct history. But, when a LKUP_ID is not selected, the logging column headers are still present. 

     

    I have done some preliminary research and it appears that it is not possible to conditionally the change the column headers background and font to transparent. I have tried doing this through the field formatting and extending to the header, but that is not working. 

     

    Any suggestions to get this working with the overlay are welcome. Thank you. 

     

    -- LKUP_ID selected

     

     

    -- LKUP_ID not selected