Bar Chart using Date as Dimension

[khanashique]

Hi Experts,

I need to create bar graph with missing dates and dates in nearby future, as shown in below example:

By Using current expression -> Sum({<Year = {"$(=Year(Today()))"},IDATE = {">=$(=Date(Monthstart(Today())))<=$(=Date(Monthend(Today())))"}>}Sales), i get the data till today only.

Thanks,

MAK.

[Channa]

check your IDATE as data till the end of the month or till today

in dimension check box allow null value 

[khanashique]

Thanks for your reply, I want to use expression in dimension.

[Channa]

ur expression is good just do this attach

[khanashique]

Thanks, i know this... but still it does not show the date where data is not available