Forum Discussion
c0nners
7 years agoRegular Visitor
Date type format set in Table, not respected in Visual (format MMMM yyyy, is plotting as DD/MM/YYYY)
Hello. Any help would be appreciated. :)
I'm setting a column to reflect dates as:
Data Type: Date
Format: March 2001 (MMMM yyyy)
Within the Table is shows the Data as above.
My issue is the visual is just a veneer, as if I use the drop down filter I can still see the value as DD/MM/YY.
So when I try to plot this as a visual I'm getting plot points for DD/MM/YY and not the MMMM yyyy.
any suggestions please?
Thanks
2 Replies
- parry2k
Super User
- c0nnersRegular Visitor
Thanks for responding, but that didn't quite do it.
I have data for Jan 2018 and Jan 2019. I can get the LineChart to look the way I'd want it using "Date Hierarchy", if I deselect year and quarter.. however it's going to group all January's in one column. I need a column for to be MMMM YYY.Ta