Show/Hide table on click of bar charts

[Anonymous]

Hello all,

I have the requirement to build two independent funnel charts to give the user the option to compare two different dates flexible. 

Therefore I have two identical tables and based on each I built one funnel chart and a date slicer. 

Now the next step is to have a table where the user can see employee details based on the selection in the funnel chart. Because I have two different tables, I would need to built two table visuals. But I only want to show the table for the funnel chart the user has clicked.

If the user clicks on chart A I want to show table A and hide table B, if the user clicks on chart B I want to hide table A and show table B. 

I did a little bit of research and the only thing I could find is to build a button and use bookmarks. But that's not working for me, because if I put the button over the chart, the user can't select anything. And i don't want the user to see the button from a usability point of view.

Has anyone an idea how to solve this problem?

[Ritaf1983]

Hi @Anonymous 

According to your description, it is not possible to give up the bookmark button because it is the only way to show and hide visualizations.
In addition, if the table is a breakdown of what's in the bar row of the funnel, it might be worth checking the Drill through option.
For more information refer to the linked document:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly