Plot date wise data on a line chart

[darshaningale]

I have Month on the X axis of a line chart and count on the Yaxis. I am using Date table to plot month on the X axis. The base data has dates in the table.

Before June i want to plot months on the X axis. After June i want to plot dates on the same X axis. 

Please let me know how to perform this.

[darshaningale · Accepted solution]

I created another column based on the Month column. For month before june i used same number. For month after June i used the actual date. and put this column on X Axis.

[PhilipTreacy]

Hi @darshaningale 

You can't.  The axis will show either one or the other, whichever is chosen.

regards

Phil