Forum Discussion
Have a table appear only when another table is filtered
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?
4 Replies
- amitchandak
Super User
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
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-msftCommunity Support
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.
PaulDBrownCommunity Champion
Anonymous
Have you considered using report page tooltips?
