Donut Chart color change

Moriz Heyss

Hi, is it possible to fix colors for a donut chart? For my dashboard I have several reports from where I get data. I have the same structure, but if one value is empty the colors change. So e.g. normally I have 5 rows. and therefor in my dashboard 5 colors. But if one row in my report is 0 than I only have 4 colors/values in my donut chart and colors changes. It would be great if the color for each row would be the same. Is there a solution for that?

Paul Newcome

You would need to add a very small decimal to each number and then "hide" the decimals. There are a number of other posts here in the Community that go into more detail about how to lock in chart colors.