Earn 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.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |