Values are not grouped in column

[Pbiuserr]

Hello,

I've created "Age" out of date and when I want to expand values in the "Data" view, I dont have grouped so its like "0", but all of the zero's are listed. Is it something of which I should be worried? Or just let it be

[Pbiuserr · Accepted solution]

Seems like after quite some time it started to work normally..

[jdbuchanan71]

If you format the age field as decimal, are they actually 0?

[ribisht17]

@Pbiuserr 

Your Age column is in the summary form or not?

How do you want to treat this? If you want to take average/sum then it should be a measure/aggregate

Thanks,

Ritesh

[Pbiuserr]

I wanna group it and use it as axis

[mwegener]

Hi @Pbiuserr,

can it be that your display format does not correspond to the actual value?

I mean do you not display the decimal places?
0,1 -> 0
0,2 -> 0
0,3 -> 0
...

[jdbuchanan71]

@Pbiuserr 

First thing that comes to mind, is the date column you are using to calculate the age actually a Date/Time with time values on it?  If so, I think that might be causing your problem.  It's not really 20 different '0' values, it's

0.1234646

0.6642364

0.8913989

etc...

Format your date field as Date/Time and post a screen shot and also share the formula you used to calculate the age so we can see it.

[Pbiuserr]

Hi @mwegener @jdbuchanan71 
The column I use as an reference is date type. I was thinking same about 0.4874 but I did it several times and it always worked - so out of column with dates I do new column -> Date -> Age, then Duration -> Total Years and then round down, so it suppose to be rounded to 0

[mwegener]

Strange, we would have to look at it in more detail with an example. Can you provide an example PBIX?