display all month days on a chart

[mambi]

Hi everyone,

in the image below i want to display also days with no sales for exemple : day 1,2,3,9,...

my expression is : sum (sales)

[#2]

On presentation uncheck the supress zero values option

[its_anandrjs]

On chart Properties >> Presentation >> Uncheck the Supress Zero Values

[mambi]

i already tried this but not working, then i  tried to check show all values on my dimension it's works but i'm getting the '-' sign after the day 31 any idea how to remove it

[anbu1984]

To remove '-' sign,

Properties --> Dimension --> Check "Suppress When Value Is Null"

[tresesco · Accepted solution]

Just above 'Show All Values', there is 'Supress When Value Is Null', check that option.

[mambi]

haven't see it lol

thanks for your help

[mambi]

i want to color the missed days lines so i used if(sum(Sales)=0,RGB(122,233,121)) in the background color option of my expression but i'm getting this results , what's the problem here ?