Hide zero data from a chart
We have a chart in which data will be at 0 for most of the year. Is there a way to tell the chart not to print the remainder of the line if it is 0? We tried to set up a member to return Nothing if...
Forum Discussion
DDrider, thanks for the response.
It is already set to True; this may work if all periods for the member had 0. Once it gets data the rest of the chart drops to 0.
I accidentally set your response as the solution, but I undid it right away.
Scott
Is this chart using cube data? If so, I would check the following on your cube view settings:
Suppress Zero Rows/Columns should be enabled
If Use Suppression Settings on Parent Rows/Columns is set to True, it will apply your suppression settings to parent rows and columns as well
Last, is there anything in the data source configuration that could be overriding these settings? Do you see the zeros if you test the data adapter (may not be possible) or run the cube view independently?