x-axis showing null value

[#1]

I am getting one bar for Null values in my bar graph, but when i am checking my data, there is no record with the Null value in my table. Can anybody tell me why, i am getting this bar for NUll value?

[Anonymous]

this basically means that there are some values returned by your expression which are not getting linked to the dimension..

if your dimension is from a different table... check the link between the tables..

usually this will be the problem..

let me know if this is not the case here..

hope that helps..

[advait_thakur]

Hello,

Please check in Chart Properties> Dimensions > Settings for Selected Dimension > Suppress When Value is Null.

Also in Presentation tab you can flag in Suppress Missing.

I hope this will help you.

Thanks,

Advait

[#4]

Hey adavit, thanks for the reply but this was the thing which i knew, i just wanted to know the exact reason for that bar showing Null values.

[advait_thakur]

Hello,

The association between the tables is not being formed properly.

Kindly check the joins, concatenations if you have any.

Thanks,

Advait