Hi Power Community.
I am trying to create a area graph with two cumulative value on it, both based on a hour value.
Here is a sample of my date :
|theroerical time||real time||Quantity|
I am using two measures to calculate my cumulative values, one for each hour :
ISONORAFTER('Quantity'[theroerical time], MAX('Quantity'[theroerical time]), DESC)
For the other measure, replace reference to theroerical time to real time.
My issue is that i can't find a way to display my two measure in the same graph because it can't conciliate my two hours column on the same x axe.
I manage to go that far. One measure is correctly cumulated, the other one is not (because X axis doesn't correspond, despite being both a hour value)
My expected result would be to have both area cumulated.
Is there a solution to allow both of my measure to be cumulated here ? My easiest take would be to concialiate the x axis but i failed to do it for the moment.