AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Dates sorted incorrectly in bar chart

[ Edited ]
Follower ✭ ✭ ✭
# 1
Follower ✭ ✭ ✭

I'm having trouble with a stacked bar chart where I want to show data by month. It might be hard to see in the screenshot below but instead of showing the months, everything shows the year, 2016.

 

chart.PNG

I have read the documentation and formatted everything correctly, I thought. The data is coming from Google Sheets. The date field in Google sheets is populated the way it says in the instructions (2016-01-01; 2016-02-01, etc). I also updated the date dimension to display in MM format, as described in the instructions. 

 

MM date.PNG

 

No matter what I do I see 2016 listed for every month. Anyone have ideas for me? I saw another post that says, rename everything just a 2 digit month, like 01, 02, etc but I don't want to do that. I want to use the date and have it sum by month, quarter, etc. 

 

Thanks in advance for any ideas!

Dates sorted incorrectly in bar chart

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

Under the Bar Chart Properties:

Edit the Data Source

Duplicate the 'Date' Dimension

Change the type to "Month (MM)"

Rename field as needed
Click done

 

Use this as the Time Dimension in your Chart.