Forum Discussion

will2018's avatar
will2018
Regular Visitor
8 years ago
Solved

Decimals

I want to remove deciamls from 2 places in POwerBI Desktop   1. My Column Headers are based on Period Numbers whcih come form a database numeric field     e.g. 2016  2016  2017  2018, but on th co...
Need Help
  • will2018's avatar
    will2018
    8 years ago

    Hi POnk

     

    Ok, with a bit of trial and error, figured it out.

    To change the formtting, you have to have the clumn highlighted in the Tables section

    When I did this, I culd change the decimals

    Also sorted ny second query

     

    Thanks again for your replies

     

     

p0nk's avatar
p0nk
Frequent Visitor
8 years ago

If you go into the query editor, select the table and right-click 'Rename' and manually change the name of each column. It may take a while based on the amount fo columns you have but it is the easiest (and only) way I know.

 

In relation to your second question, in the query editor you can select the column and go to Transform, Rounding. From here you can set the amount of decimal places for a colum, but only works if the column type is numerical.