Forum Discussion
Data formatting - Numbers are identified as text
Hello everyone!
I'm kinda new to PBI and stumbled across a problem that I have no idea how to solve.
In query editor I have a table with column formats set to match the data types. Column "Сумма" format is explicitly set to number.
When I try to add amounts to the matrix table or to any visual the amount is added either to Columns or Rows but not to data fields. Any ideas?
Thx in advance for any tips or help.
9 Replies
- Pragati11
Super User
HI Anonymous ,
Can you click on your column on the FILEDS pane ansd check what data format it has got on the top ribbon as shown below:
Thanks,
Pragati
- Fowmy
Anonymous
Possibly, it could be formatted as TEXT in the data model though you set the type as Number in Power Query. Please check.
If it doesn't work, make sure any subsequent steps in Power Query didn't change the type.________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
- amitchandak
Anonymous , I doubt it is still a number. Check in the column tools . Change if needed
- Pragati11
Hi Anonymous ,
No creating caluclations or measures won't affect the datatype of the column until it is chnaged explicitly.
Thanks,
Pragati
- negi007
Community Champion
Anonymous there are three places where you can change the data type (you can't change text to number if text has non-numeric characters)
1. source : Define the data type in the source data if possible
2. power query: change the data type here if you can't change it in the source
3. Power Bi desktop: finally, if it is not possible to change the data type in above two cases then change here. There are few data type which are only supported in the power bi desktop
- v-easonf-msft
Community Support
Hi , Anonymous
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution.For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,
Community Support Team _ Eason
