Hi All,
I seem to have a problem where there are duplicate colors appearing in legends.
I was able to get around this by using WINDOW_MAX([Dimension], First(), Last())
But I have ran into another problem where for certain dimension the sort order is lost.
i woud want the years in a desc order but now with the fix they are in ask order
I tried to follow the article https://kb.tableau.com/articles/howto/sorting-by-fields-with-table-calculations?_ga=2.42949541.185231198.1669037523-1202690397.1662016604 but not sure how to apply it in my case as i am not displaying sum([sales]).
Any help in how to
1) avoid duplicate colors
2) if 1 is not possible, how to sort a window_max calculated field in desc order
Thanks.
Hi @Akshar Jamgaonkar ,
Colors are not determined by your calculations, they are set by the user on the 'color card' (Under Marks > Click 'Color' > Click 'Edit Colors'). The reason they are duplicating is because you are using the default Tableau colors, and there are only so many available. If you want to change the colors, you can do that under this interface.
To sort your legend, just hit the arrow in the corner and select 'sort' from the menu. You may want to review some color best practices, more than 5 or so on a chart is strongly advised against.
Thanks,
-------------------------------------------------------
Mike Manning (Tableau Forums Ambassador)
*Please mark this answer as best if it helped resolve your question*
