How to make a classification calculations for dates

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

if you want it without "-" sign , you can use ABS function:

Days over due _ ABS =

var overdue_date = TODAY()-15

Return

ABS (DATEDIFF([Due Date],overdue_date,day))

modified pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

And use this column as a legend of the donut :

In terms of effective data visualization, the donut chart isn't suitable. It's difficult for us to compare the lengths of the donut segments, and it requires interpretation of colors and playing "ping pong" with the legend. This means that interpreting the graph would require unnecessary resources for no reason, and it's a graph that wastes valuable real estate on the dashboard. The appropriate graphs in this scenario are: Since we're examining the quantity of actions exceeding a logical axis (the range of days), and the questions are about ordinality ("where are there many overdue actions and where are there few"), the suitable graph here is a column graph sorted by the logical order of the ranges (like a histogram). For example :

And if the purpose of the donut was to show the distribution of the whole, then it still doesn't change the question that needs to be answered, which is whether the quantity of overdue actions by many days is greater than those overdue by fewer days or how it is distributed. It's essentially the same comparison, just showing different units of measure. And if there's still a need to show some kind of fraction, you can create a graph with a "filling jar" effect using a stacked and framed graph

The absolute qty in this case can be on a tooltip :

The updated pbix with all examples is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.