Decimal/Whole Number columns not being recognised as number columns

[doubleclick]

Hey, 

Why are all the number columns in my data model not being recognised as numbers. My model is powered by csv files and I've checked their format in power query + loaded up into a fresh data model where it works. 

They are missing the big E symbol in the tables tab and do not show to option for summarization yet i can still do calculations with them?

Is there some kind of master option for this? is there any help any of you can provide?

[v-stephen-msft]

Hi @doubleclick ,

So can you successfully manually modify the data type to number?

Under Transform, click Detect Data Type or select the data type manually.

If the data type can be successfully modified,, auto-detection may not be turned on.

Go to Power BI Desktop, Options, GLOBAL, Data Load, Type Dectection.

Automatically Detect Data Types in Power BI - Carl de Souza

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[doubleclick]

thanks, this was already turned on, i believe the issue when certain time intelligence measures have been included and that i need to efit the model.bim file 
i haven't tried it yet to confirm but the problem seems exactly the same, it's here:

https://community.fabric.microsoft.com/t5/Desktop/cannot-summarize-number-field/td-p/1126656

[foodd]

Share both your work-in-progress Power BI Desktop file, as well as the source CSV, so that members of the Forum may take a look.

[doubleclick]

i am unable to do that because this is sensitive work information