Forum Discussion
Formatting X Axis - display all values in order
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.
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! :smileyhappy:
4 Replies
SeanCommunity Champion
Is it also set as date in the Modeling tab?
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
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! :smileyhappy:
