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

1. When you rename the headings of the columns, you should jsut be able to replace 2017.00 with 2017. I am not sure why it is adding decimal places onto the column header.

 

2. Apologies, I misunderstood you. If you go into the the data view, select the column and go to the modelling tab, you should be able to set the decimal places under the formatting section. However if you want accurate results, I would just leave the data as it is as there is no real need to round unless you are going into 5 or more decimal places. 

will2018's avatar
will2018
Regular Visitor
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

    That's alright, I forgot to say that in my answers. Sorry about that but glad you have sorted your issues.