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

Reformat date data label on bar chart.

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

Currently, my bar chart x-axis data label format is [%Mmm %DD, %YYYY].  I only want the date to be formatted as ["%Mmm %DD].  Is there a function I can use on the dimension to reformat the date?

 

Thanks,

Spencer

Reformat date data label on bar chart.

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hi Spencer: Yup... You will have to edit how the Dimension is formatted.

 

Resource > Manage Added Data Sources > Edit . Then search for "Date". You will see all of your options there.

Re: Reformat date data label on bar chart.

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I believe editing the data source format only affects the way the date is interpreted and read into Data Studio.

The issue is at hand here is how to change the data are labeled along the X-axis... am I mistaken?

 

Re: Reformat date data label on bar chart.

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Are you using a time series chart?

 

Does this work for you?

 

Screen Shot 2017-03-27 at 3.08.17 PM.png

Reformat date data label on bar chart.

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

In this case, a time-series line chart doesn't fit the bill... it's more important to have a data represented as stacked bars with suboptimal labels than it is to have perfect date labels on a line chart.