What do you mean by exact date? You can choose the day, month, and year in the date drop down. In your workbook Exact date is selected, but why can you not use the dates above that?
Thanks for the reply.
By exact date, I mean I had checked off Exact Date from the drop-down:
As you can see, even if I select Month, the x-axis continues to display years. I would like to display months (and years). I know how to format a date, but I don't know how to make Tableau display the months of the years in this specific scenario (dual axis Gantt chart with continuous dates) That would also require more space in order to be able to display all of them, and I am OK with having to scroll to the right.
I am going to give you some documentation just for the dates feature of Tableau.
You can go through them and decide which one fits your needs best. I was thinking that the Date Values or Not Continuous Dates are what you are looking for. The Exact date looks like the data has to have the format that you want to show the way you want to show it before it gets into Tableau.
Yeah, I mean I searched online before posting (and I knew about that link). If you are willing to show me how this information can be applied to my case, I would be super grateful.
Please post the Tableau workbook I've attached if you feel like you have figured out the solution.
1 of 1 people found this helpful
Above the rows shelf, in the top-center of your screen, there is a drop-down menu--your's probably says 'Entire View'. Change it to 'Standard' and then press CTRL + Right until the viz is as wide as you want it to be.
In order to change the markings on the axis--right click on the axis at the bottom of the viz, and select 'Edit Axis'. On the 'Tick Marks' tab set the major ticks to appear every month. Hit OK
Right click again on the axis, and go to 'Format' On the left hand side of your screen, from the 'Dates' drop-down you can specify exactly how the date should appear on the axis (pick a preset format or select 'Custom' from the bottom of the drop-down and enter your format, e.g. mmm 'YY to get Sept '16). After this, you may need to use CTRL + Right again to make the viz even wider, if you want every month label to appear.
Hope this helps.
That's it - thank you so much Andrew - that was great. I was missing the CTRL+ left/right - thank you for pointing that out.
Appreciate you spending the time to help me.