Forum Discussion
AdministratorPower bi doesn't recognize dotted text
Good morning, I have a table of sales items that there are some that have a point in the middle like this "003.21335", the issue is that power bi does not recognize it, in the report view if I put a table with all the sales items these do not jump and obviously if I want the sum of the sales of this group does not make it correct since it is as they did not exist. I do not know what problem there is and I do not know how to solve it. Does anyone know where it can come from?
Thank you
4 Replies
- Arul
Super User
It is due to data type of the column in which these sales items are stored. Try to change the datatype of that column to decimal if it is in other data type format.
Thanks,
Arul
- Arul
Syndicate_AdminI have already solved it, it was an excel table that had the wrong data type in the excel. Thank you
- Syndicate_Admin
I can not do it, it can only be text (nor does it let me change it), since they are references of articles of products that may have comol the one I have commented, but there are also some with letters for example "000332M" or also with a bar in the middle "882/2325", in these two cases power bi does not "eliminate" them, they come out without problem in the view informs. It only stops showing me or does not take into account, the references that have a point in the middle. Thank you
