Total Value in the table does not tally with the Chart

[KTP_UBS]

Hello,

By referring to the screenshot below, could you please advise on the following scenario?

1. I exported the data from the table into a CSV. The sum of Requested Budget is 91583592 and Total Confirmed Grant is 21923744. There is no function applied to these two attributes on PBI Desktop

2. However, when I drag these two attributes to plot a chart where sum fuction was applied, the chart shows Total Confirmed Grant as $62053373 and Requested Budget as 192202324 which is incorrect. The expected result is Requested Budget is 91583592 and Total Confirmed Grant is 21923744

3. These two attributes are from the same query table

Thanks.

[v-qiuyu-msft · Accepted solution]

Hi @KTP_UBS,

In your scenario, I would like to know how do you design the chart? Do you just place Requested Budget and Total Confirmed Grant columns in Chart Value property? Does the dataset contain duplicate records? Please check if you have specified any filter condition on Table visual. Also please select the chart then convert it to the Table visual to see if the total values are the same as the original table visual.

Best Regards,
Qiuyun Yu

[KTP_UBS]

Thanks @v-qiuyu-msft. It was the duplicates that causing the problem. All sorted now. 

[Baskar]

Hey KTP

1. Do you merged the table with any other table ? if yes check the merging function.

2. check the tabular report which u have in second like check the total . let me know.

[KTP_UBS]

Hello Baskar,

Yes, I did a few merges and one Group function. 

Thanks

KTP

[Baskar]

Did u got different Total output from Tabular Report & Bar Chart  ?

if no am sure u have prob with your Merge Query ...

am always in online pls reply we will fix the issue soon ....

[Nhallquist]

Typically, I see this when there is not a unique record identifier in the dataset.  do you have a key or Index in this data that is unique to each record?  If you don't, try adding a column.  you can contcatenate a pair of columns that would create a unique index for each row, or bring one in from the data file,or even manually add an index column to the data file.  I would start there and see what comes up. 

Nate

[KTP_UBS]

Thanks Nate. I have created a new column ID which the value is the sum of Grant ID and Projects ID. It still does not work 😞