Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
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!