PowerPivot 2013 - strange behavior when converting text to numbers RRS feed

  • Question

  • In my first attempt to use PowerPivot 2013 for Excel I found an unusual behavior in string conversion. It is well known that all measures came as text and not numeric.In my case Windows is configure to use comma as decimal separator, but when I generate a table the separator is a dot, as shown below.

    As these numbers are percentages, I needed to convert them as decimal number. When I changed them from text to decimal number look what I got. The column of Measure "Trabalho Acumulado" that means Cummulative Work is ordered in ascending order.

    I got completely different meningless numbers and decimal separator comes in wrong place.

    Is that normal? Help wanted.

    Thank you. 

    Best regards, Ricardo Segawa - Segawas Projetos / Microsoft Partner

    • Edited by R.Segawa Wednesday, January 23, 2013 1:31 AM
    Wednesday, January 23, 2013 1:29 AM


  • Hi,

    dont change the data type, just change the format to percentage and it should convert it.

    I think the problem is that, that field came as text (see your first screen capture) so it is not converting properly

    when importing the data do by a SQL query and use convert/cast functions.

    hope this can help

    Thursday, March 7, 2013 3:35 PM