Can I apply different color saturation scales to differerent columns when there is only one measure?
I have created the attached highlight table showing the percent of survey respondents that correspond to chosen dimension values. There is currently only one color saturation scale for the entire chart. I would like to have a separate scale for each column so that if 10% is the smallest value in one column it would have a light shade and if 10% is the largest value in another column, it would have a dark shade. I know that it is possible to have a separate color legend for each measure in a chart, but there is only one measure in this chart. Is there a way to do this?
Hi @Amelia Kohm
My approach would be to create separate [Number of Respondents] measure values for each column like
IF [Category]='Furniture' THEN [Sales] END
Then drag those values into the sheet. It will bring a measure values field into the marks card and drag its copy to color shelf as well. Right Click measure values and choose "Use Separete Legends". Then you control the color of each column separately.
Check the attached file
If you have further questions, let me know
If this helps to solve your issue, please select it as the best
Thanks,
Said
