Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
3 years ago

Stacked chart - always show zeros

Let's say I have a stacked chart that shows two categories. When one category's value is zero it is not shown in the chart. Can I enforce it to show all the time?   Thanks
Need Help
ouaelaam's avatar
ouaelaam
Icon for Resolver I rankResolver I
3 years ago

You can use a measure like this :
IF(

ISBLANK( [Value] ),0,
[Value]
)

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
3 years ago

ouaelaam The value is not really blank, it is numeric zero.

  • ouaelaam's avatar
    ouaelaam
    Icon for Resolver I rankResolver I
    3 years ago

    You can try to replace 0 with a very small value like 0.00001.