Hello,
I am attempting to set a visual based on the selection in another visual.
I have two visuals:
In visual 1, I have X rows with say 12 different columns, and only showing 7 → Three “defining rows” and 4 strings or values
In visual 2, I have the same rows, showing the same three defining rows, plus the other 5 values/strings.
I want visual 2 to be hidden by default, and when any row is selected in visual 1, visual 2 becomes ‘shown’ and that specific value is seen.
I’m trying to make the bottom right visual only appear when the bottom left is selected and show that data. I can use the selection action on the left to narrow it down, but its either “show everything” or "stay hidden.
Like, the default state for the second visual would be [hidden but all data] and then when a selection/row is picked on visual 1, visual 2 becomes [show but only row selected].
But we have no consistent values. Having the rule as "show if not equal to null() " doesn’t work correctly.
Basing on previous threads, I’ve come to these conclusions:
This level of dynamic may not be possible
I’m missing how to set up parameters
my rule set up is incorrect.
This is a major knowledge gap that I just cannot cross right now.
I’ve tried a bunch of variations, but I am just not having luck.
One thread says just to use a parameter and then a rule to avoid null(). Another will say to make a parameter into a calculated field into a control into a rule(but only with set values).
I know it’s something with conditional rules and I’m 90% sure it requires a parameter, but this also all seems like far too much of a work around to just make a visual show based on a single selection.
Without seeing the details of your data, I can’t be too specific but the following solution should work. I’m just showing one parameter in my example but you’ll have to create three - one for each of your “defining columns”. Repeat the same steps for all your parameters.
Create a parameter like this and set a static value which is not found in your visual.
Click on the +, select the parameter that you created and select the field which should be used to set its value.
Hide your second visual by default and add a rule to show it if the parameter value is not the static default that you chose.
When you click on a row in your first visual, the value in that row will be passed to the parameter. Since the parameter value is not the static default anymore, your second visual will be displayed. Since the parameter is also linked to the filter on your second visual, it will show the row which contains the parameter value.
Hi @ocataylo,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed.
