1.5K members online now
1.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

months (Jan, Feb, Mar....) are recognized in text format and not months in pivot table

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

i have data for different months. I have named the month as Jan, Feb, Mar and so on. When i draw the pivot table, it recognizes months as text and arranges alphabetically and not as per calender.

months (Jan, Feb, Mar....) are recognized in text format and not months in pivot table

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

Instead of creating the month in text format (Jan, Feb) in your dataset, make sure you have a date field. Then, in your datasource setup in Data Studio, create a month from that date using the formula month(date) and make sure that it's set to the MM format type. Then pull the new month dimension into your chart. It should now put them in calendar order.