Forum Discussion

Ganesh08's avatar
Ganesh08
Frequent Visitor
3 years ago

Change Data type.

Hello Guys,

 

I have created the data inside power bi with the help of create table option. But when i created this table it automatically assumed data type as text for all the columns and i cannot change the data type to integer now using neither front end nor back end  !!

 

what can i do??

Need Help

4 Replies

    • Ganesh08's avatar
      Ganesh08
      Frequent Visitor
      3 years ago

      Hello, Its something this like this and I created it, using Create table option in power bi

      • JadhavVarsha_13's avatar
        JadhavVarsha_13
        Helper V
        3 years ago

        Thank you for sharing the data Ganesh08 

        I guess you wont be able to change Name and Type but Month can be converted to Numeric Value. 

        have you tried using Transform Option ? 

        Power Query Editor -> Transform -> Data Type -> Whole number 

        Or from Power BI Desktop -> Data View -> Select the column you want to change -> Column Tools -> Format