Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Formatting

Hello!!

Need some help to put all the numbers in a table with the same format. As you can see in my atached print, the number format is different for the first two columns and I want to change that format to the other columns format. Any way to do that?

 



Thanks!!

  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Can you check the data types in Power Query if you get your data through PQ?


6 Replies

  • Anonymous , under column/measure tool you can change the number format

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      amitchandak I already did that, but the format doesn't change... they're all as decimal numbers, but the format doesn't change.

       

       

      I want to put the first column numbers as the other ones. (Example: planned= 5.238.538 and budget released = 1.605.900) 

      • Fowmy's avatar
        Fowmy
        Super User

        Anonymous 

        Can you check the data types in Power Query if you get your data through PQ?