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 tha...
Need Help
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

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


amitchandak's avatar
amitchandak
Super User
5 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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
      5 years ago

      Anonymous 

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


      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        FowmyOh... yes, that's it! I can change the format trough that, however it still doesn't appears as the other ones. So I change the first number to decimal, but it appears as 5238538,00 instead of 5.238.538,00. Any way to do that? If not, I will have to change the other values to appears without the ".".