Help | Months are not in correct order

[Jrun14]

When I create a vertical bar chart with all 12 months I want January to start on the left through December on the far right I have numeric data for each month that I have added to using labels. I want to see the trend month over month. For some reason I cannot get the chart to rearrange the months in order.

I also have another vertical bar chart that I created where I want to view data by quarter for example Q1, Q2, etc.. Starting with Q1 on the far left. This data set also has numeric labels.

I try sorting both tables through ascending or descending and I cannot seem to get it right. 

Any help would be greatly appreciated. Thank you, in advance for your consideration/expertise help here!

[lauratilton]

What are you using for your sort metric? It sounds like it might be sorting on a metric? Are the date fields formatted as Date in the data source, or are they just text?

[Sichali1]

Hi

To make sure your months appear in the correct order from January to December, start by checking that your date field is properly formatted in the data source. Next, create a calculated field using MAX(Month), which will help Looker Studio sort the months correctly. Apply this field as the sorting option and set it to ascending order.

Also, remember to duplicate the date field twice, once to convert it to Month and once to convert it to Quarter. This will allow you to toggle between monthly and quarterly views easily. When switching between months and quarters, simply use the up or down arrows in the chart settings, and Looker Studio will handle the sorting automatically. With this setup, your data will always be displayed in the correct order.

For expected results, click the link below.

https://lookerstudio.google.com/reporting/dbfc95b3-b172-4895-af6a-323da1ac69c7/page/VJlCF