Sorry if I wasn’t clear in my earlier post – that’s not at all what I was proposing. Let me try to illustrate with a better example. Here’s a simple bar chart. The data bars and the title are controllable by conditional formatting, but the axes are not. So what I’ve done is placed rectangles over the two axes, each controlled by conditional formatting of the background, like the card overlay in our previous discussion.
When the sample size equals or exceeds the threshold all the conditional formatting measures get a value of BLANK(), meaning they assume their default color. If the sample size is less than the threshold value, then they all received a value of white, making them indistinguishable from the background but still technically “visible” – thus you can still activate the tooltips by mousing over the visual and also select the visual header options. Similarly the title is conditional on the status of the threshold versus the sample size.
I hope this is helpful and meets your requirements. I’ve attached the full revised solution file, so you can see how all the different components are configured.
e DNA Forum – Show Hide Visual Based on Threshold Value Solution2pbix.pbix (368.8 KB)