Forum Discussion

dobregon's avatar
dobregon
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Scatter plot with 2 measures in Y Axis ( problem )

Hi guys,   I have a problem with the scatter plot, i'm doing a power curve (for wind turbines) with X Axis: Wind speed Y Axis: Power   Giving something like this This is great, the probl...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi dobregon 

 

Download example PBIX file

 

Try using a Line and Clustered Column Chart. Put the Power values in the Line area.

For the Shapes (Line Values) set the Stroke Width to 0 and turn on Show Marker, then set the marker size and color. You can Customize each series individually if you wish.

Regards

Phil

  • dobregon's avatar
    dobregon
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    PhilipTreacy This is very usefull, i can use it, but the problem is that i have thousand of points for me visual and the scatter plots can work with 3500 values and the line&clustered chart works with lower number of values. This produces average numbers to reduce the information

    Do you know another visual / or other solution? For the moment, probably i will use it


    • Cado_one's avatar
      Cado_one
      Icon for Resolver III rankResolver III
      5 years ago

      Hi dobregon PhilipTreacy 

       

      I am currently facing the exactly same issue to build power curves for wind turbines.

      To have all the points displayed in the scatter chart we can check the "Don't summarize" option for wind speed and for power.

      But with line and clustered column chart I don't have this option so I'm forced to have averaged or summed values ...

      How can we deal with that ?

       

      Best regards Cado

      • dobregon's avatar
        dobregon
        Icon for Impactful Individual rankImpactful Individual
        5 years ago

        Cado_one it seems that we are doing the same visuals (exactly wind turbine power curves :D)

        The scatter plot is the good one to create the visual becasue it has a limit of 3500 points (the line chart doesnt have that number of points)

        So, if you are goind to do Power VS wind, you need to use the scatter plot

        The scatter plot has an option to show yo differnet points depending of the legend, so if you want to compare and you are able to use it is the best way

        Related to the line clustered chart, i have used 3 measures (power, powerexpetect and wind speed) all of them with average agregation becasue the visual as it can't take all the points it needs to aggregate the information. The problem in that type of vissual is the precission, becasue scatter plot has more precision (due to number of points) than this chart.

        On the other hand you can use phyton visuals that it can give to you everhing