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

Line chart sort by date - Feature request

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

 I have two line charts, the time dimension is "hour" and breakdown dimension is "date", I'm unable to edit the charts so the legend colours match the dates in each chart.

issue.PNG

edit for clarity:

Top chart:       April 8, April 22, April 15, Apr 1

Bottom chart: April 8, April 15, April 22, Apr 1


Please can we have this feature? or can someone tell me what I'm doing wrong?

Line chart sort by date - Feature request

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

What do you mean when u say "the legends match the dates."?

Re: Line chart sort by date - Feature request

Follower ✭ ✭ ☆
# 3
Follower ✭ ✭ ☆

Top chart:        April 8, April 22, April 15, Apr 1

Bottom chart:  April 8, April 15, April 22, Apr 1

 

Because I can't order by date, the colours assigned to dates in each chart aren't aligned.

I'll edit my post to make this clearer.

Re: Line chart sort by date - Feature request

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I see what youre saying.

 

Click on chart and on the right go to style. 

 

Under style, there will be an option to assign color to each line. 

 

You can change from that by selecting each corresponding series.

 data studio.JPG

Marked as Best Answer.
Solution
Accepted by topic author Andrew S
May

Line chart sort by date - Feature request

Follower ✭ ✭ ☆
# 5
Follower ✭ ✭ ☆

This issue has been resolved since I posted.

The solution you have would work for static reports, not dynamic ones. The "breakdown sort" has now been included on this type of chart which resolves this issue. Thanks for the assist!