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 am updating a spreadsheet table (data source) to add a new column of data and creating one new measure and updating 3 others with the new measure. Now, the pie charts with this data are showing double the amounts for ALL measures, even the ones I did not edit. Here my steps:
1. Went to Edit Queries and found that it needed to be reconnected to the updated sheet, did that.
2. Verified the table showed the same values as the spreadsheet for all columns and that the new column appeared and was in the correct format (whole number). Below is a screenshot of a part of the new data; the new column of data is the 3rd from the end (NRCS SOD EQIP Funds):
3. Clicked on Close and Apply
4. Went to the Data tab on the left and clicked on the Measures Table and clicked on New Measure
5. Created the new measure: Total NRCS = SUM('FundingSummary'[NRCS SOD EQIP Funds])
6. Updated a current measure used in a couple of pie charts to add the above measure:
And this is what is shows now:
I have no idea why all of the values are doubling! Any help is appreciated!!
Sande
Solved! Go to Solution.
I went back and double (ok, probably quadruple at this point) checked my work and found that I was pulling the Total line from the spreadsheet into the query. Therefore, it was adding that amount to each column, thus doubling all the amounts. Duh... rookie mistake! LOL
I went back and double (ok, probably quadruple at this point) checked my work and found that I was pulling the Total line from the spreadsheet into the query. Therefore, it was adding that amount to each column, thus doubling all the amounts. Duh... rookie mistake! LOL
The FundingSummary Table is where all the data is stored from the spreadsheet. That data is used to create the Totals measures that are used in the pie chart measures. The Totals measures look like this (the value in the [ ] is the column header on the actual Excel spreadsheet):
The pie chart uses these measures (these are before I added the new data):
Hi @SandeA ,
The meausre "USDA APHIS & NRCS" has a part more than "USFS APHIS": [Total NRCS]. This is most likely the cause.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
What measure was it using before? How is the FundingSummary table related to the other columns used in the pie chart?
When you say:
@SandeA wrote:
Now, the pie charts with this data are showing double the amounts for ALL measures, even the ones I did not edit. Here my steps:
What do you mean by 'even the ones I did not edit?'
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |