Forum Discussion
Solved
Power Bi Tables Total Row is missing
Hello, Experiencing an issue when I create a table in Power Bi the totals row will not load. I have this enabled under the format area, but it will not turn on. Data type/Format are set to whole ...
Any measure that is marked with the Sigma in the field list should display a total by default when totals are on. Is there a chance that the field was switched to "Do Not Summarize" if you click the dropdown arrow next to the field name in the Values section?
I am having the same issue. My column is formatted as a whole number, and under values, I don't have the option of clicking Sum.
I don't know if you're still having this issue all these months later, but it sounds like your field isn't numeric.
I would double-check that. Maybe format as decimal or something and see if that does anything.