The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
So what did you actually do in order to make it work? im sitting with the same problem
I believe I have figured this out.
I had to create a new measure. PowerBi is not as intuitive as I expected.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
1 | |
1 | |
1 |