Could you please send the sample workbook
Right click on the date and select exact date else
Just right click on Month of Month Axis and go into Edit Axis-->Click on Tick Mark and set the interval.
Please let me know if you face any difficulty.
Hi Suman - Thanks. I tried it but didnt get the way its required. If I select Excat Date (from custom) then I do see all the months however, then the Date is displayed as Janaury 1, 2016, and there is no option to change it to 01/01/2016 (MM/DD/YYYY)
Yes, You have option to change it.
1 of 1 people found this helpful
To show every month on the axis, right-click on the axis and choose "Edit Axis". Then go to the "Tick Marks" tab and set it to fixed with an interval of 1 month.
Just be aware that, as you add more and more data, those labels will get smashed together, which will be problematic. Leaving it as automatic prevents that from happening.
Tableau automatically determines the start and end point of the axis based on what's on your chart. In other words, it needs to make sure everything fits and it prefers to leave a bit of padding on either side. This is why you're seeing dates in 2015. If you want to remove those, then edit your axis again, go to the "General" tab and choose "Fixed". Then set a fixed start of "01/01/2016"
But, again, be aware that this will keep that fixed start date, even if your data starts to include dates prior to 1/1/16.
Hope this helps.
Than You very much for the reply. Could you please also also share the workbook ?
Thank You all for your responses they were really helpful