Line chart, value sorted

[Post]

Hi together,

i have the following data in excel: (with a lot more entrys)

In table content like this:

Date	0,063	0,125	0,25	0,5	1	2	2,8	4
23.08.2019	7,46	8,47	11,16	21,14	52,89	93,00	100,00	100,00
06.09.2019	5,39	6,30	8,02	14,36	34,69	89,31	100,10	100,10

I would like to visualize tis table like i did in excel:

I´m trying for 2 hours now but i dont get it. Can you please help me.

Tanks a lot!

[Post]

Thanks for the quick answer!

I import it from the excel table via power querry.

And i have a relation between dimdate and the date in my table

I can´t show any visuals because thy don´t work.

[vanessafvg]

how are you placing this data in power bi can you share what you have done?

also can you show your relationships? (layout) view?

[vanessafvg]

are you able to share some sample data in text form?

[Post]

Yes:

Datum	0,063	0,125	0,25	0,5	1	2	2,8	4	8	11,2
23.08.2019	7,46	8,47	11,16	21,14	52,89	93,00	100,00	100,00	100,00	100,00
06.09.2019	5,39	6,30	8,02	14,36	34,69	89,31	100,10	100,10	100,00	100,00
13.09.2019	6,77	8,28	12,13	27,14	54,90	94,90	100,27	100,27	100,00	100,00
20.09.2019	11,35	13,43	17,23	29,75	51,60	93,40	100,34	100,34	100,00	100,00

Is this ok?

[vanessafvg · Accepted solution]

see attached. I unpivoted the data in power query.  

[Post]

Thnaks i also tried this. But i dont get it like this in Exel

The y-axis ist from 0-100% and on the x-axis there should be the name of the columns.

Thanks for your patience

[vanessafvg]

is this how you want the data?

[Post]

Yes, i figured it out how to sort the data. Your tip with the unpivoted data was the solution!

Thank you!