Date format in MM DD YYYYU

Question

Hi,

I am trying to convert the date format into MM/DD/YYYY from various options. Tried custom date format from dimensions tab and also date pill from the rows column. However, i am unable to get the desired output. I want to have something like this in tableau (screen grab below for reference). Ex: I have different transactions occurred on various days. Wanted to look each transaction by date and value.

Answer 1

Hey Deepak, please follow these steps:

1. Right click on the pill or click on the down arrow

2. Click on more(highlighted in red)

3. Go to Custom. In this custom date window select the Month/Date/Year Option

Hope this help :) Let me know otherwise!

Answer 2

HI SriDeepak,

   You can try clicking on Tooltip and write the order of the date like this after drilling it down to Month/Week/Day level.

Other way is to check which date format ( Continuous /Discrete ). Then click on options given below or click more to use custom formats

You can view detailed day transactions like this when you hover over the date.

Hope this helps you.