Forum Discussion

c0nners's avatar
c0nners
Regular Visitor
7 years ago

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

    • c0nners's avatar
      c0nners
      Regular 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