cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
SharePointAU
Frequent Visitor

Data Values Showing as 1 Instead of Actual Value

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. 

1 ACCEPTED SOLUTION
SharePointAU
Frequent Visitor

I believe I have figured this out. 

 

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

View solution in original post

1 REPLY 1
SharePointAU
Frequent Visitor

I believe I have figured this out. 

 

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.