Forum Discussion
Sorting and visualizing data
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!
First part is fixed now, thanks
Second, not much, i did as u said, made attribute and Values on all of the temps, so i have like 10 values and attributes
But still putting them into graph seems to be the hard part, for me right now at least. I am trying to put them in Line chart and in Fields, i put the dates to axis, the attribute to legend and count of value to...value. But i get one straight line with the value of 1(count of value)=How to i change this to just value and not count of value?. There is no option next to it, only remove field, count(distinct) and count
Maybe it's formatted as text so he can't do anything else? Did you check the data type?
Yes, it's text data type, but if i change it, to decimal or whole number, the tables Value goes to "Error" Had the same thing with first part, so i had to split it( Temp)
If it's text it can't do anything else. You must solve that in some way. Hard to tell how without the file. Try some transformation query on query editor like adding a coulmn like Number.FromText
Did you strip the units off of the temperatures leaving only the number, or do the values still contain "°C"? Conversion from text to number would only work if the units are not present.
