Have a table appear only when another table is filtered

[Anonymous]

Hi there

I have two tables on a page. Table 1 shows scores by month, Table 2 shows the name of the agents and their scores.

So, when you click on a score in table 1 it dynamically filters Table 2 to only the agents who have scores in that month.

But, Table 2 is useless unless you've clicked in Table 1 because it just shows everything for all time. So, I want Table 2 to only appear when someone has clicked into a cell in Table 1, then disappear when someone clicks out of Table 1. 

Can I do this?

[PaulDBrown]

@Anonymous 

Have you considered using report page tooltips?

[amitchandak]

@Anonymous , Actually you will be able to hide. But you can have transparent background and font color unless something is filtered

if(isfiltered(Table[Column]), "#000000", "#FFFFFF00")  // black for font

if(isfiltered(Table[Column]), "#FFFFFF", "#FFFFFF00")//white for background

use in conditional formatting using field value option

[Anonymous]

@amitchandak 

I've tried a few combinations and I'm just getting either black font or no font, no matter if Table 1 is selected or not. What should I do for black font if selected, white font for unselected?

Hidden Table = IF(ISFILTERED(VerintData),"#FFFFFF","#000000")

[V-lianl-msft]

Hi @Anonymous ,

This blog is about solutions to similar cases:

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.