Forum Discussion
Helper VBasic 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.
Super UserThat's where the unpivoting comes in. It allows you to then do the transforms on a single column.
Helper VYou 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?
- lbendlin
Change the column type of the Value column to a numeric type.
- PPStar
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?
- lbendlin
Can you provide sample data, or describe the structure of the sharepoint list fields?