Data Values Showing as 1 Instead of Actual Value

[SharePointAU]

I have successfully added my SharePoint list as a source. I select fields to use as data, but the values are being shown as "1" and not the value of the field.

Example: "The Number of Sites per Day" --> I have created on the axis, and "# of sites" as the Value.

The bar chart shows each date with a bar value set to 1. The actual value of "# of sites" is in the thousands. 

Example: There are 3 rows of data. Each with several columns. Each row, or item represents a snapshot of totals for that day. I'm trying to get a bar chart to show the trend of "# of Sites" for each day. However, when displaying this data it shows the data as though each line is a value of 1. Reguardless of what is in the columns i'm using.

Why is it counting this as 1, and how can I change it. 

[Anonymous]

So what did you actually do in order to make it work? im sitting with the same problem

[SharePointAU · Accepted solution]

I believe I have figured this out. 

I had to create a new measure. PowerBi is not as intuitive as I expected.