Forum Discussion
Solved
Normalize time series data to initialize at zero
Hi. I have the following line chart with a cummulative PnL. My issue is that I want the line to start from zero no matter what time interval I am viewing with the slicer. So substractin...
I think I finally found the solution:
The following measure did the job:ScaledToZero = VAR min_val = CALCULATE(Min(Performance[ValueDateTimeUTC]), ALLSELECTED(Performance[ValueDateTimeUTC], Performance[PnL])) RETURN Min(Performance[PnL]) - CALCULATE( SUM(Performance[PnL]),Performance[ValueDateTimeUTC] = min_val)
Hi MahyarTF.
The problem is not to change the y-axis, but to scale the time series such that it starts at y=0. I am pretty sure there is no chart setting that can do this job, but a measure has to be created.
Best
Jesper