Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data from Excel not showing in Table Visualization

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 S...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      v-deddai1-msft
      Community Support
      5 years ago

      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