set blanks field to numeric null i.e 0

[#1]

Hello community,

Today i have a graph problem,

here is some screenshoot, I want to set the values of the x axis, i dont want it to  change. i want to set Missing field value = numeric 0

It X axis année (year in english), i always want to see all values like on image 1, but sometime when i make a selection all value dont appear (Image 2)

For example in this case i want to have a curve pass trough zero at année = 2012, 2013, and 2014.

[PrashantSangle]

Hi,

try

1)uncheck Show all Value from dimension tab.

2)Presentation tab uncheck ->Supress Null and Populate Missing Cell

Regards

[#3]

Thanks Max Here is my dimensions Tab, i dont see "Show all value" section

Thanks

[PrashantSangle]

Hi,

Afficher toutes les valeurs means show all values

is your dimension is calculated dimension??

Regards

[#5]

no its not a calculated dimensio, it a field that i load

[#6]

I dont have a choice to uncheck this case, it Bizarre

Another idea?

Thanks

[PrashantSangle · Accepted solution]

Hi,

In expression try below

if(isnull(expression),0,expression)

Regards

[jsingh71]

hi teneman,

If you dont want your chart get updated based on the selection then select the Read Only property from the chart properties as following: