2 of 2 people found this helpful
Of course, you would just have to set a parameter which takes on the choices of column names, let's say [Choose color mark].
Just create a calculation that's something like:
if [Choose color mark] == 'A' then [Column A]
elseif [Choose color mark] == 'B' then [Column B]
else [Column C]
And just place this calculation on color, and show parameter control.
Excellent, Thanks Matt! Now the question is how to have a dynamic color legend...
It's not dynamic? what happens?
Nevermind! I had to add the sheet back to the dashboard for the new parameter and legend to show up. Works perfectly!