Unable to add any number column to values in Matrix or summarize then in a normal table

[doubleclick]

Pbi heads, need some help. I've got a large and complex data model i've been using for years. For some reason all the number (both decimal and whole number) columns are no longer being identifed as number columns (and are missing the sum symbol next to them on the data pane)

I've tried changing the format in the primary horizontal ribbon to Decimal number (for some reason they were all under general) but i still can't add any of these number columns to the values section nor can i sumarize them. Wierdly, i can use them in measures and measures can be added to the matrix/tables values

I vaguely remember being annoyed at the constant summurization so i may have turned it off somewhere but not sure if i dreamt that