Forum Discussion
Using Measures as Axis in line chart
I would like to build a simple graph like the following (from Excel - X-axis shows running total quantity, and the Y-axis shows per ton margin. ): Now, I managed to put this in PBI using ...
foyiq,
Create a calculate column that represents running total using DAX below, then create line chart and check if you get expected result.
Running Total COLUMN =
CALCULATE (
SUM ( 'Result'[Aggr.Qty]);
ALL ( 'Result' );
'Result'[Index]<= EARLIER ('Result'[Index])
)
Regards,
Lydia