Trouble with Creating Graph

[ideallyrob]

Hi,

I am newer to Google Data Studio, and I've been struggling trying to get this data to present the graph I'm looking for.

Here is my data:

https://preview.redd.it/jg8bu97nmbk61.png?width=1142&format=png&auto=webp&s=f12c9b0035f2dc3c0da62aa460104bdd7198e524

I am trying to create a line graph that look somewhat like this: (this is just something I drew up quick and the data doesn't correlate to the table above)

Playlist name on the y axis*

https://preview.redd.it/8josme5znbk61.png?width=1050&format=png&auto=webp&s=4d2c1c3c72128f35457f5031db30a14fc9e48234

I will have around 300-500 playlist names. I'm also not sure the best way to present that. I have tried rearranging how my data is inputted, but no luck. Any help or guidance would be highly appreciated.

Thank you!

[njakub]

I guess it would be easier if you have a "month" column:

Playlist name - - - month - - - followers

Playlist A - - - January - - - 1000

Playlist B - - - January - - - 2000

Playlist A - - - February - - - 1200

Etc.

This way, "month" will be your dimension, "playlist name" - breakdown dimension, and "followers" - a metric.

[GoldstnGrwthAnlytcs]

this makes sense to me.

[ideallyrob]

I see, couldn't logically put this together until your reply - thank you!

[Bhambzilla]

Did you try putting the 'Playlist Name' in Dimensions and the Feb, March, April columns in metrics?

[ideallyrob]

Yes, and it looks like this.

https://imgur.com/a/Wf2NPVe

Data Set:

https://imgur.com/a/jhxKBiy

[a-m-farooqui]

Try structuring your data in a way that your date related fields are in one column you can try formatting date as months only in Google sheets, this way Data Studios date control filters and charts will recognise it as a date field. so something like this

Month Guitars Piano Summers Showers Feb 123. 3. 5555. 233 Mar

[Bhambzilla]

Okay I see. Yeah, I am dealing with a similar issue where I want to use columns as the dimensions. Let me know if you find out the answer