How to Change Values in Map Based on Parameter in Tableau
Subscribe: http://bit.ly/3i3WN4p How to Change Values in Map Based on Parameter in Tableau
Let's take a look at how to swap measures in a map using a parameter. Right now I'm showing sum of quantity on color so if quantity is high like in California then it's going to be a darker blue. If it's low like in let's say Georgia then it's going to show a light blue .What if I want to give the end user the ability to swap between quantity sales and profit. I'm going to create a parameter first to drop down here create parameter have it be a text parameter a string and give the user a list they can choose quantity profit or sales.
call it chosen measure. Show that on The View here chosen measure. I'm default to the quantity right now create a calculated field I call it map color. It's going to be a simple case statement let's zoom in a little bit.
It's going to be case chosen measure. When profit then sum of profit when sales then sum of sales and when quantity then sum of quantity.
All case statements end with the word end. I need to find that calculated field I just called it color map color. I'm going to replace quantity with map color and you'll see that the colors change based on My Chosen measure. Right now I have quantity and change it to profit and change it to Sales.