I've been having this issue while building dashboards for a while. I want to use a pie chart, the data contains 4 series. The values will update via their formulas over time, but right now the value for 3 of the 4 series is 0. For all of the other types of graphs, all series are displayed in the legend regardless of their values (for example, in a bar graph all of the series show up on the axis & in the legend even if their current value is 0). However, when I choose pie chart (or donut), the series don't show up if the value is 0, meaning the only thing that shows up in the legend is the series with a value above 0. Furthermore, when the values for the other series update, they get added into the pie chart & legend, but then my series colors get all messed up & I have to go back & fix them. How do I fix this so all of the series show up in the legend even if their current value is 0?
