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

How to show date as only year and month

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am creating a graph using data in a google spreadsheet and I want the date along the horizontal axis to be labeled as Month and Year, but it continuously shows up as Month, day, year. For example, in my spreadsheet I have "6/2017" but it still shows up as June 1, 2017 in both the formula box of spreadsheets and on the horizontal axis of the graph. Is there a way to fix this?

How to show date as only year and month

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

For the google sheet: Set the custom format for the cells as "August 5" from the options list... Format --> Number --> More Formats --> More date & time formats.  

 

In Data Studio: You can specify the "type" of your field as "Year Month (YYYYMM)". This shows up on my graphs as "July 2017".

Note, My data coming into DataStudio is formatted as yyyy-mm-dd.