I originally created the first heat map shown below with one measure: Number of Respondents [calcuation: COUNTD([Uniqueid])]. However, I want a heat map that has seprate color legends for each column. The column headers are controlled by a parameter [Select Breakdown] and a calculation [Breakdown Calc]. So, as shown in the second image, I created separate measures for some of the column headers, e.g. IF ATTR([Breakdown Calc])="Charter" THEN [Number of Respondents] END. Then I put Measure Names in the filter pane (and selected the relevant names) and put Measure Values on color and label and selected to "Use Separate Legends" on color. As you can see, the legends were correctly created--they show the right range of values. However, the shading and labels on the chart are NOT correct. I'm stumped! Can anyone help? Please see workbook attached.
Hi @Amelia Kohm
Your file included a link to Tableau Server. Please save as a fully-packaged TWBX so we can better address the issue.
This may be as simple as making sure your default color ranges are set, but I won't know until I have a better look.
Thank you!
Michael Hesser (Tableau Forum Ambassador)
If this response has answered your question, kindly click "Best Answer"
