Data Values Showing as 1 Instead of Actual Value

SharePointAU — Wed, 29 Mar 2017 19:13:46 GMT

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.

Re: Data Values Showing as 1 Instead of Actual Value

SharePointAU — Wed, 29 Mar 2017 20:19:34 GMT

I believe I have figured this out.

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

Re: Data Values Showing as 1 Instead of Actual Value

Anonymous — Fri, 31 May 2024 11:13:50 GMT

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

topic Re: Data Values Showing as 1 Instead of Actual Value in Developer

Data Values Showing as 1 Instead of Actual Value

Re: Data Values Showing as 1 Instead of Actual Value

Re: Data Values Showing as 1 Instead of Actual Value