Is this the format you are looking for? If you click the date, change to the bottom Day option and swap it back to discrete...you can right click the values in your viz and do format with the full range of options.
BTW...you have to go back into the compute > advanced menu for each table calc and move the date fields back over to addressing from partition.
Sample WB_v2.twbx 72.9 KB
This is exactly what I want however I have having trouble reproducing this.
Are you clicking on the 'Close Date' and/or 'Paid Date' in the Dimensions field or on the Rows shelf? And I thought the measure was discrete to begin with?
Yup I understand the updating the compute part.
I clicked on the date pills on the rows shelf, chose the second day option that has the full date. It'll change the pill green and continuous, messing up the viz. But then you click the pill again and change it back to discrete. After that, you should be able to right click the values in the viz and select format. The format menu on the left has the option for custom mm/dd/yyyy.
Ah got it that worked! Thanks so much!
Do you know the reason why it changes it to continuous when you do this?