Duration curve

[JGG]

Hi, I would like Power BI to calculate the sort order - sorting consumption from high to low and present it as a duration curve (not sure if this is a proper name for it) shown in the graph above. Now I have the logic in Oracle with column "Sort order" but then date date range is fixed and I want this to be dynamic so it updates by the date slicer. Then the duration curve and consumption curve will use same data set. Any tips on how to fix this?

JGG

[amitchandak · Accepted solution]

@JGG , in case you have a column that is at same granularity and have sort order you can make that as sort column

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[JGG]

A new column with date (YYYY-MM-DD-HH24) saved as data type text in Power BI made it work. I doesn't seems like Power BI accepts changing the sort order of data type date.

[Greg_Deckler]

@JGG - Sort By column?