Data from Excel not showing in Table Visualization

[Anonymous]

I have a column in an Excel file that whenever I sync to PowerBI Desktop, values from some columns will not be recognized. 

From the photo shown below, when I check in Excel, total value of "MTD Sales Target" column is 608,452.08 and total value of "PLS" column is 3402.38.

However when I load it to PowerBI and use table visualization, the numbers from the "PLS" column is shown as zero only. 

Any help on the issue would be very much appreciated. Thanks!

 

[amitchandak]

@Anonymous , Open Transform data/edit query. And check the data type pLS is should be number/decimal. Change it check.

or right click on table open adavance editor. Does it show data type as Int* , if so change to number. (Keep backup of file)

Save and check

[Anonymous]

i tried your suggestion and it worked for the first column that i have that problem with. however, there are other 3 remaining columns that has the same problem and when i applied the same steps, the values appeared as zero.

the solution was only applicable to the first column that i had a problem with. any advise?

[v-deddai1-msft]

Hi @Anonymous ,

The total value in table visual will calculate sum of all the value in PLS column instead of showing value in your source data. In your screenshot. all value in PLS column is 0, so the total value is 0.  Did all value in PLS column for each month is 0?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai