How do you make bars show up even for null values?

[#1]

So I have a bar chart with two expressions. I want both expressions to show up in the legend even if one of them is always null. Originally I was doing this: If(IsNull(Value), 0, Value) as the expression and it worked, but now it doesn't seem to be working.

I unchecked the Suppress Missing and Suppress Zero options.

Anyone have any ideas?

[#2 · Accepted solution]

try using expression like: sum({<set>}sales) - sum({<set>}0)

[Gysbert_Wassenaar]

If the dimension contains numeric values you can set the dimension axis to Continuous on the Axis tab.

[#4]

That worked! Thank you so much!