Changing the column name from a Date Hierarchy field

[andrewleal]

Hello everyone, 

I created a column that subtracts a due date from the current date, to calculate how many days the assignment is overdue. 

code looks like this: 

Days overdue = TODAY() - TABLE[Due_date]

This works fine and dandy and graphs out the days over due like a champ, however the column name is set to "Day" because I enabled the "date hierachy" option.  How can I change this column name? If I switch it to "days overdue" in the values column it will just spit full dates with no graph. 

Any help would be greatly appreciated!

[Hasan · Accepted solution]

You can use the Query Eddiot/Add Column/Date/Age to calculate the Age and turn into days

[andrewleal]

i guess that graph is a new feature of powerbi? I did it the same you told me and it worked the way I needed it to, thanks!

[andrewleal]

is there a way to make that column look like the graph i posted above by chance? thanks for this!

[aroldan]

I'm not sure but check out this option maybe helps you.

[aroldan]

The result is something like this

IS A TABLE

[aroldan]

Can you post pictures? because I don't know if I understand it well.

[andrewleal]

My apologies, it must've not posted the first time, here is the column w/ the graph:

And here is the were I switched it from Date hierarchy to the column name of "Days overdue"

I'm also open to other solutions for this column.