Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
You can use the Query Eddiot/Add Column/Date/Age to calculate the Age and turn into days
You can use the Query Eddiot/Add Column/Date/Age to calculate the Age and turn into days
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!
is there a way to make that column look like the graph i posted above by chance? thanks for this!
I'm not sure but check out this option maybe helps you.
The result is something like this
Can you post pictures? because I don't know if I understand it well.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |