Forum, Tips & Tricks

Learn tips and tricks and engage in discussions with our blog authors here. It’s all for your benefit and learning. 

You need to log in to create posts and topics.

Convert text to number

When you are working with Excel file and upload data to PowerBI, the columns format often changes from number to text. But it is possible to convert text to value after upload.

Here is an example:

  • First select the column in your data model.
  • Then click on „Home“
  • In the drop-down list filter „Data type“ select „Whole Number“.

Thank you! Hope you find this useful.

Uploaded files:
  • 2-zvolit-cislo.PNG