How to visualize a 0 in a stacked bar chart

[o59393]

Hi all

How can I visualize a value of 0% in a stacked bar chart ?

As seen below it´s only showing values above 0:

I tried a table but it obly showed values above 0 too:

The formula I used to calculate those % values is:

KPI Sludge = 

VAR R1 =
CALCULATE(
COUNTROWS('Append (Sludge)'),
'Append (Sludge)'[Column]="IN")

VAR R2 =
CALCULATE(
COUNTROWS('Append (Sludge)'),
'Append (Sludge)'[Column]="OUT" || 'Append (Sludge)'[Column]="IN")

Return
DIVIDE(
    R1,R2
)

Basically you divide total In by total In + total out

Thanks !!

[o59393 · Accepted solution]

Hi

I solved it. Added a +0 to the divide function:

Return
DIVIDE(
    R1,R2
)+0

Regards!