Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to change column format from text to numerical?

Hi,

 

In POWER BI, when I pull the data directly from excel certain numerical columns come by defualt with Summation symbol but some are not (they appear probably as text).

 

For those, which are appearing with summation symbol when any graph or visualization tool is used, various options like sum, Max, min, average etc., are available, and for those without summation symbol only count is available. 

 

Is it possible to manually change the format of the column so that all numerical column will have options like average, sum etc.,?

 

Numerical column with summation symbolNumerical column without summation symbol

 

 

Regards,

Prem Kumar R

Need Help
  • TristanKuesters's avatar
    TristanKuesters
    9 years ago

    Very easy, choose the field and then under the ribbon moddeling you can choose the data type.

3 Replies

  • TristanKuesters's avatar
    TristanKuesters
    Icon for Resolver I rankResolver I
    9 years ago

    Very easy, choose the field and then under the ribbon moddeling you can choose the data type.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks for your reply.

       

      Actually, intially the data type options was greyed out for me, but it works now and this helped to change the format as per requirement.

  • MarcelBeug's avatar
    MarcelBeug
    Icon for Community Champion rankCommunity Champion
    9 years ago

    In the Query Editor, you can see a step "Changed Type"  when Excel files are imported. In that step you can adjust the type.