Forum Discussion

Jonnokc's avatar
Jonnokc
Frequent Visitor
10 years ago
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 ...
  • deldersveld's avatar
    deldersveld
    10 years ago

    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?

     

    TableTotals.PNG

deldersveld's avatar
deldersveld
Resident Rockstar
10 years ago

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?

 

TableTotals.PNG

acouto's avatar
acouto
New Member
9 years ago

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.

  • thegeo's avatar
    thegeo
    Frequent Visitor
    8 years ago

    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.