Forum Discussion
Helper IVClustered bar chart X-axis with time
Hi all,
I have a clustered bar chart where the X-axis is a time series and the Y-axis is a quantity value for product count comparisons between two systems. I doubt that is important to any of you as the only thing I am having a problem with is the X-axis time series. Basically, if I use a date slicer and restrict the date to a few days, I start getting the following:
October 10, 12:00PM
October 11, 12:00AM
October 11, 12:00PM
October 12, 12:00AM
Et cetera...
Is there a way to remove the 12-hour ticks from the clustered bar chart and have it display only the day? This only happens when the chart has such a little amount of data that it seems that the visual tries to include half-day increments even though there's no time data really. If anything, my time data is as follows: '2017-10-10 00:00:00.000'
My data never has time--to my knowledge--apart from the general zero hour. Even if it did, I just want to show a whole date.
Any help is appreciated and let me know if I need to give you more information!
Regards,
Derek
10 Replies
- Greg_Deckler
Community Champion
You should be able to just change the format of your column to Date instead of Date Time.
jderekcHi there, smoupre! Thanks for responding. My column data types are now "Date" but the issue persisted. Previously the column data types were date/time, but I chose the M/dd/yyyy format. Please see the included screenshots for what it looks like when I select only a few days versus what it looks like when I select more days:
Only a few days; get half-day ticksNo half-day ticks
- Greg_Deckler
Hmm, that's odd. Well, you could create a new column and use FORMAT to ensure that it strips out the time information and then just use that column instead.
Alternatively, go into your query in Query Editor and switch the data type of your column there so that it comes into your data model without the time information.
