Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
@Anonymous
Have you considered using report page tooltips?
Proud to be a Super User!
Paul on Linkedin.
@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")
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.