Formatting X Axis - display all values in order

[SamRounsevell]

I'm trying to show a count of sales alongside the quantity of outgoing communications on the same day:

If I choose Continuous it shows the dates in the correct sort order but hides most values:

If I choose Categorical it shows all values but loses the correct date order:

How can I display every day while keeping it in date order?

I have both a Date Hierarchy and the raw Date field (set as a date type in the query) changing between them doesn't seem to help.  

[Sean]

Is it also set as date in the Modeling tab?

[SamRounsevell]

Aha!

My Date field (not the Hierarchy) is Data Type: Date in the modelling tab.  

This is great but for some reason I can only

That is in order but only displaying values with data (transaction count in this case).  
The Categorisation option under the X-Axis to show all values is not available now.  

The Date Hierarchy field has all the Modelling buttons greyed out when I select it.

I'm planning to upload a table of Dates and a Count of mail pieces, TV spots ,etc...could I cheat and just put a value in for every day with 0's for empty days?  Would that force the graph to display each day?

Edit: Thank you very much for helping 🙂  

[Sean · Accepted solution]

The other thing I noticed in your first post - in the second picture (when the X-Axis is Categorical)

Thy sorting the Chart - Sort by the Date - it looks like it was Sorted by Transactions

Click the ... in top right corner of the Chart and Sort By Date

Yes if you have all dates you can create a column

Column = 0 and place it in the chart - that will force all dates to be seen

however you won't be able to use the legend if you do this...

HTH!

[SamRounsevell]

Ah, I never knew the sort function was there 🙂  Perfect, thank you very much!