I have a stacked bar chart with a legend. Some of the measures are occasionally zero depending on the choice of dimensions.
I don't want to see a measure in the legend if the measure is zero.
How can I do that?
I want red and green gone from the legend (for my currrent choice of dimensions).
In the chart properties, under Add-ons > Data handling try unchecking Include Zero Values.
Hope this helps.
Retrieving data ...