This content has been marked as final. Show 2 replies
Hello all ,
So i wanted to ask if there is a possibility in tableau , where each filter selection could have its own color legend.
So i have a table with columns 1) categories , 2) sales , and 3) states of usa associated with them ,
Now i am trying to build a filled map where i apply the sales amount on color legend , so on the view i have the usa map with sales amount on label , so i get a gradient( all categories selected) with different colors are shown based on the legend ranging from red to green.
Now when i select a particular category only red on all the states is shown because the sales amount for a single category is towards the minimum of the color legend, but i need color gradients , so i was wondering if there is a possibility to have color legends with different ranges for each filter selection.
SO MY COLOR LEGEND RANGES FOR ALL CATEGORIES FROM 1,187 TO 35 BILLION
BUT MY RANGE FOR A SINGLE CATEGORY SHOULD BE SOMEWHERE IN 234,567 TO 789,987 AND I HAVE 72 CATEGORIES.
hope there should be a way out through this.
Thanks in advance