Forum Discussion
Solved
Sorting and visualizing data
1. My table looks something like this temp1 names min right-now max temp10 name1 6 7 13 temp11 name2 9 10 53 temp2 .... 12 14 35 temp3 temp...
Hi helger. I'm not sure exactly what you want the graph to look like, but if you want something where you have a line for each name, your data should look something like this:
Date Name Temperature
1/1/2015 NameA 23
1/1/2015 NameB 24
1/2/2015 NameA 25
1/2/2015 NameB 24
Power BI really works with a columnar storage engine, so each value or attribute should be in its own column. You can do things like max/min/average as calculations on top of this so just storing the raw data is easiest.
Hope that helps!
Or if it is possible change table names. For table names lower than 10 add prefix 0. temp01,temp02... it will order tables in a correct way.