Forum Discussion
Decimals
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
HI ......Many thanks for your reply
Point 1.
I renamed the column , but I can't see anywhere that I can specify zero decimals
Point 2.
I have done as you suggested , by going to the raw data and 'Rounding ' it.
However, dont think this will give accurate results
I could have say 1,000,000 rows and if I round at each row level, when it sums , its not going to be very accurate
Say I have a million rows, and 5 product groups, summing all the rounded values not going to be very accurate
What I was hoping for, was for PowerBI to sum say the 1,000,000 rows into 4 groups say, and then Round the Total, but only round at the total level....I think this would be more accurate rather than first rounding each individual row
e.g.
Val Ronded
1.5 2
1.5 2
1.5 2
1.5 2
---
8
1.5 * 4 = 6.0 rounds to 6 if doing at total level rather than individual row level (Which would give 8)
(An exttreme example but for illustration purposes only)
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.
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
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
That's alright, I forgot to say that in my answers. Sorry about that but glad you have sorted your issues.