Forum Discussion
Basic Graph from SharePoint List
Your data comes in as a wide table with ever increasing column count. That is unfortunate and not something you want to do in Power BI. First step is to unpivot your data to make it narrow, and with fixed column count.
You probably also want to change your month column to a more future proof yearmonth column. Usually you can use a date field (for example the first day of each month) and then tie that into your calendar table.
That's where the unpivoting comes in. It allows you to then do the transforms on a single column.
Your an absolute diamond, i dont think there is a need to unpivot, although it will make it look tidier, But changing my month column to a year month and then changing that to the first day of the month and tieing that to the date table would be the solution. Genius solution.
My next question is, how would i easily change the month column to Month and Year.... I can create a custom column, but i dont want to do that for every single month, can i create one new column that looks at the column title and appends the year column on it?
That's where the unpivoting comes in. It allows you to then do the transforms on a single column.
You are absolutely right, i did it and it now shows my data in a better format .
However, i am trying to create a graph to show month on the x axis and the month value on the y axis.
(i created a relationship from Month Year from SPO and the Date Table).
I put the Month Year from the Date Table on the X-Axis and when i drag the Sharepoint month value, it for some reason keeps doing a count.
In a table format, my data looks like this
But when i put it on the graph, it looks like this
How can i get my graph to show the actual values opposed to doing a count?
Change the column type of the Value column to a numeric type.
i changed it to whole number and its still the same.
However, by default, its is Multi line of text as the values can sometimes be text.
Is there a workaround for that?. some content types will store values as text and the rest will store as number. - i wanted to avoid creating duplicate months to store integers and text?