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

Re 1st query, to clarify, the actual Data is taken ffrom a table (Not the Column Names)

So there is a column in the datatbae called Year (Date would be 2016 2017 2018 etc) and is is this Data that appears on each column

So If I have 3 years data , it pivots to 3 columns say 2016.00  2017.00    2018.00 and I want to remove the decimals from the heading column

 

Re 2nd query, tried that, can see  Modelling Tab, and Formatting Option where decimals, % etc can be changed

However, this block is greyed out when I go into it and I cannot change anything

Does it need to be enabled somewhere