Set colors for specific values within charts (other than bar charts)

  • 1
  • Question
  • Updated 2 months ago
  • Answered
I'm trying to set certain colors for values within an aggregate model (or any model, really).  Say the values are either "Off Track" (Gray) or "On Track" (Green).

I have them sorted alphabetically, so Off Track becomes Group 1, On Track is Group 2.

But when the model returns 0 records for Group 1, and [All] records for Group 2, the donut chart displays Gray, because that is the first color listed in the colors section.

Rob Hatch posted a snippet here of how you can "lock" colors in a bar chart; it works fabulously for those, but he wasn't able to modify it for other chart types.  Wondering if anyone knows how we can get it there?
Photo of Monica Lorey

Monica Lorey

  • 384 Points 250 badge 2x thumb

Posted 4 months ago

  • 1
Photo of Bill McCullough

Bill McCullough, Champion

  • 10,122 Points 10k badge 2x thumb

I don't know if this is still important to you, but I posted 1 solution to 'locking' in colors for a chart.  I applied it to the Funnel Chart, but you should be able to adapt it to other charts.[settings][f...