I want it to look like this when there’s no data
if anyone can help it would be greatly appreciated
And how is it now? Share more information, it’s easier to help.
Can you share a screenshot of what it current looks like when there’s no data?
Ok while I’m not familiar with this particular chart, here’s where I’d suggest starting:
Trying adding a Is Not Empty
and then a Formatted As Text
. Under the Formatting as Text, Formatting for Yes: This sum of Unit
Formatting for No: 0
. And then on the other side of 'Formatted as Text'
, add a 'Converted to Number'.
What you’re doing is telling it 'If this data point is empty, show a 0 instead.
Do you have any other data sources available under the ‘Formatting for yes’? There should b e something similar to the Value expression, so something like ‘Current point’s sum of Unit’ or something like that. Before typing the word ‘this’ for this screenshot, what other sources did you have?
this is what it looks like now and do I just type 0 in the the “formatting for no” are?
also on the other end
this is what it looks like
That’s correct-
Are these new screenshots what you’re expecting based on the data?
When I try to type 0 after the "converted to number it doesn’t stay
btw I truly appreciate your patience btw
Ah that ‘0’ should go in the ‘formatting for no’ field
Happy to try!
Thank you for the info/answer!
This topic was automatically closed after 70 days. New replies are no longer allowed.