Forum Discussion
Solved
Line chart, value sorted
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!
see attached. I unpivoted the data in power query.
8 Replies
how are you placing this data in power bi can you share what you have done?
also can you show your relationships? (layout) view?
are you able to share some sample data in text form?
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?
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.
