Hi!
I have a scenario where I need to change the shape of the data point that was selected in the drop down filter. All the other values need to be seen but only one value needs to change color and shape. Is this possible?
I have a mocked version below. This is a screen shot from a dashboard where the filter "Name" is being used on other sheets. As soon as we select another name from the drop down, that person should be marked as a star.
I thought about actions but it would need a separate sheet to trigger the event.
Thanks!
Rishi
If you create a parameter with all the values present in the scatter chart and then set the shape equal to the following calcualtion the shape will change based on the parameter value
[Parameter]=[Field]
This returns a True/False.