date(date#()) function

[diana_]

Hi,

In my dataset I have column Period with dates 01/01/2018, 01/02/2018 in a format of Jan-18, Feb-18 etc. and another column with numeric months (1, 2,...12).

When I prepare a combo chart I would like to have month abbreviations (Jan-2018, Feb-2018, etc) on x-axis, however I can only get desired visualization with numeric month values, when applying function =date(Period,'MMM-YYYY'), the chart looks  not the way I wish (stacked columns look like lines),the formula for date does not give intended result (MMM-YYY) (picture 2). I have no problem with the same date function in other charts though. Could you please advise the solution? 

Picture 1Picture 2

[Vegar · Accepted solution]

In your X-axis chart properties, try to disable the continuous axis. (Disable auto handling and uncheck "use continuous axis")

[diana_]

Thanks a lot. It worked!