1 of 1 people found this helpful
Please select the date filed as continuous one then you will get custom option in format.
In this example, the symbols used to represent "03Jan2016" format is "ddMMyyyy."
Here is an arbitrary selection of examples:
Add text next to the numbers: "Profit:" #,##0.00;"Loss:" -#,##0.00; Replace the numbers by text: "Profit";"Loss" Numbers in tens: 0"."0;-0"."0 Numbers in hundreds: 0"."00;-0"."00 Numbers in trillions: #,##0,,,,.00T;-#,##0,,,,.00T Show only positive values: #,##.0; ; Show only negative values: ; -#,##.0; Add leading zeros to a number: #,### 000000000 Split numbers into dollars and cents: #,## "USD &" .00 "Ct"; - #,## "USD &" .00 "Ct" Add symbols: #,##0º Show Quarter instead of Q: yyyy "Quarter" q Times instead of dates: hh:mm:ss Only the months: mmmm Show the full date and am/pm time: ddd, mm/dd/yyyy, hh:mm am/pm Special syntax like telephone numbers: (###) ###-###-### Don’t show anything at all: ; (I am not sure why you should want to hide everything, but you never know.)
Thanks for your quick Response.
If we do like that, it will display continuous monthly trend, but I want to see the discrete monthly trend
Thanks for your quick reply.
The main problem in this scenario is, it is not showing the custom formatting option (In the above screenshot you will notice this)
The two previous replies do not address your issue completely. Yes, if you switch to continuous dates you can format them as desired but perhaps you need to use discrete dates (the dates you have pictured above). The best way I've found is to create calculated fields that display the discrete date the way you would like. I've attached a sample workbook with two such calculations: "date name and year" and "numerical date." You'll see I also sorted the new date field on the original date field.
Hope this helps!
date calcs.twbx 1.3 MB
once you change the date field to continuous and then you check the format options you will find the custom option . The same i showed in my screenshot.
1 of 1 people found this helpful
This can be achieved by the below steps
- Month(order Date) needs to be continuous and it should be like "Month ,Year" as mentioned in the screen shot .
- Right click the axis and click "Format" and then you have option to change the "Scale" of the axis as mentioned in the screen shot .
- Change that to custom format "MM/YYYY" as mentioned in the screen shot .
2 of 2 people found this helpful
Here are the steps, assuming you're beginning with discrete YEAR(Order Date) on columns:
1. Select the second Month option - 'May 2015'
2. Then select 'Discrete'
3. Then click the pill and go to 'Format' - in the dates drop down menu you should now have the 'Custom' option available
It is a little confusing that by default the custom options aren't available when originally working with discrete dates--but these steps will get you there
All of your Replies have helped me. Now, I'm in little bit confusion to mark the correct answer, Whose Reply I need to mark as correct answer?
If Tableau adds the option to mark more than one reply as correct answer, that would help the people to see the lot many ways to resolve one issue. Because while searching for a solution for some issue in Tableau community and if the issue is answered, People like me will look at the correct answer only, and will not go to the other responses. So, if Tableau adds that option (to mark more than one reply as correct answer) then it will help the people like me to look at lot more ways to resolve one issue.
Anyway, The easiest way is mentioned by Andrew Connolly, So I am marking his Reply as Correct Answer.
Pooja, Tharashasank and Sathya Raj: All of you mentioned the correct solution, but after converting it to discrete, once again we need to do format, so we will follow the ANDREW CONNOLLY solution for the easiest way.
@Paul Mathewson: Thanks for your solution, You have defined a one more new solution to resolve the issue.
@Pooja Gandhi: Before Posting this question, I read your Tableau Ambassador Spotlight interview. Heartiest congratulations to you. Thanks to Tableau for this kind of appreciation and encouragement to people.