Forum Discussion
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...
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?
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