Sort line graphs from highest value to lowest (Load Duration Curve or Duration Curve)

[Andoni_herrera]

Hi everyone!

I'm trying to build a Load Duration Curves (LDC) or Duration Curve in power BI, which are curves that sort line graphs/plots from their highest value to lowest value, despite their X-axis values (like dates, categories or any kind of axis data). Resulting in a curve that starts from its max value to its min value going through every value in decreasing order, like the picture below!

load duration curve

In the X-axis, since you lose any reference of what the axis data was or its original order, usually a percentage of the total number of samples is used as an axis (in this case the X-axis).

I'm trying to turn this line graph of marginal electrical costs of different buses (nodes) in a system to Duration Curves, despite the date a certain or any cost was registered.

Line graph to be turned into LCD

Any help or tips, will be highly appreciated.

Best regards,

Andoni

[Andoni_herrera]

@amitchandak Ok, I have the following Table.

Data Table

Which has the electricity costs at different locations (AJahuel, Charrua, Crucero, DAlmagro, ...) in an electrical system per date. I want to graph the costs of every location, like a duration curve, that is sorting each column individually despite the date they were registered, from their highest value to lowest value.

The picture below shows an example of this, in blue you have the original data sorted by date and in red you have the duration curve of that data, which is sorted from the highest value (in the Y-axis) in decreasing fashion to its lowest value (in the Y-axis too), regardless of their date.

lcd example

In fact since you don't care about the date or time a sample was registered when building a duration curve, a percentage of the total number of samples is used as the X-axis. That is, for example, if you have a column of data of 1000 samples and sort them from the highest value to lowest value, the first 100 samples would be the 10% of your graph, the following 100 the 20%, the following 100 the 30%, and so on. In my particular case, I just want to plot the duration curve (red line), the original data (blue line) doesn't need to be in the same plot.

I hope this makes it a little bit more clear!.

Best Regards,

Andoni

[amitchandak]

@Andoni_herrera ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.