Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
I believe I have figured this out.
I had to create a new measure. PowerBi is not as intuitive as I expected.
I believe I have figured this out.
I had to create a new measure. PowerBi is not as intuitive as I expected.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |