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 ,

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