Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Creating dynamic Load Duration Curves, dynamic sorting of linechart from largest to smallest y-value

Hi all Power BI wizards,    I have a large dataset with various energy values for each hour across several years. Each unique hour has 3 sets of values (one of each of the 3 different pricing zones...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Anonymous ,

Below is my table:

I create two column:

* Rank = RANKX(ALL('Table'), 'Table'[ue], , DESC, DENSE)

* Percentage = DIVIDE('Table'[* Rank], COUNTROWS(ALL('Table')))

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous , 

 

Thank you very much for your time and support. 

 

Unfortunately, when I try to replicate your approach I am still left with the problem that the LDC datapoints are not equally distributed across the x-axis. 

 

I have made an identical copy of your approach, but I cannot get the same equal distance on the x-axis. -I also cannot change the x-axis to % in the "Visual" menu. 

 

Please see attached screenshot of the problems here: 

 

What do you suggest? 

 

Best regards,

Niels

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Try to change the x-axis type to Categorical to get the same equal distance.I placed the percentage calculation column directly on the x-axis.

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous , 

       

      Thanks for your swift reply.

       

      Setting the x-axis type to Catagorical is not an option, it needs to be Continuous. Otherwise a horizontal scrolling-bar will apear for larger data sets. My actual data set must be able to show several thousands datapoints at once in the chart without the need to scroll back and forth.. 

      Do you know how to fix it? 

       

      I got the percentage working by setting the data type for the column to "percentage" in the Table View. 

       

      Thanks, 

      Br Niels