Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative chart does not cummulate

Hi Power BI Community! I want to show a cumulative chart after what delivery time span all deliveries had reached the customers. At first the chart looks fine but the line must always...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , I think this because of sorting issue. I am assuming you have also created a sort column as I can see 10-15 at the correct position

     

    do this on sort column

    Cumulative PO to delivery =
    CALCULATE([Total PO],
    FILTER(ALLSELECTED(TrackET),
    TrackET[Delivery time frame sort]<= MAX(TrackET[Delivery time frame sort])))

     

    where sort would be like

    Delivery time frame sort =
    var _diff = datediff([PO Date] , [delivered on],DAY)
    return
    Switch ( True() ,
    _diff <= 2, 1 ,
    _diff <= 5, 2 ,
    _diff <= 10, 3 ,
    _diff <= 15, 4 ,
    _diff <= 30, 5,
    6
    )

     

    what is sort column - https://www.youtube.com/watch?v=KK1zu4MBb-c

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , I think this because of sorting issue. I am assuming you have also created a sort column as I can see 10-15 at the correct position

 

do this on sort column

Cumulative PO to delivery =
CALCULATE([Total PO],
FILTER(ALLSELECTED(TrackET),
TrackET[Delivery time frame sort]<= MAX(TrackET[Delivery time frame sort])))

 

where sort would be like

Delivery time frame sort =
var _diff = datediff([PO Date] , [delivered on],DAY)
return
Switch ( True() ,
_diff <= 2, 1 ,
_diff <= 5, 2 ,
_diff <= 10, 3 ,
_diff <= 15, 4 ,
_diff <= 30, 5,
6
)

 

what is sort column - https://www.youtube.com/watch?v=KK1zu4MBb-c