Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
dobregon
Impactful Individual
Impactful Individual

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

dobregon_0-1617093234631.png

This is great, the problem is that i need to see (at the same time) the expected power, having something like this

X Axis: Wind speed

Y Axis 1: Power

Y Axis 2: Exp Power

The problem is that i can't put 2 Y axis in the visual. The other option that i have (and i used in other scatters) is to put in legend, but it is not possible in my system due to my database doesnt have these 3 valeus only and they are in columns (instead of rows).

Anyone knows another scatter plot visual or any help to do that?

Kind regards!



Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
2 ACCEPTED SOLUTIONS
PhilipTreacy
Super User
Super User

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.

dots.png

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

Hi @dobregon 

 

If it can help you I found a turnaround to have everything on a single view 

Cado_one_0-1618413933963.png

I did it by superposing the scatter chart and the line chart visuals and disable the background. Then fix the Min and Max values for the X and Y axis, hiding the titles and the axis on one of the visuals and it does the trick !

 

Have fun,

Cado

View solution in original post

10 REPLIES 10
PhilipTreacy
Super User
Super User

Hi @dobregon  @Cado_one 

Could you use Python visuals?  Can you supply some sample data and I'll see what I can knock together.

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


@PhilipTreacy  thanks for the reply, i've never used phyton visuals. i need to take a look more further in this type of visuals.

I have a simple/stupid question, the phyton visuals has the posibility to be filtered when you click on a project/device/whatever... from other visuals? like i have in other visual a map of projects in the world and if i click there i want that the phyton visuals will be filtered.

Regards!



Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Hi @dobregon 

 

If it can help you I found a turnaround to have everything on a single view 

Cado_one_0-1618413933963.png

I did it by superposing the scatter chart and the line chart visuals and disable the background. Then fix the Min and Max values for the X and Y axis, hiding the titles and the axis on one of the visuals and it does the trick !

 

Have fun,

Cado

Anonymous
Not applicable

Hello Cado, do you know if there is a way to change the scale of both plots at the same time, when we use a filter?

dobregon
Impactful Individual
Impactful Individual

@Cado_one  jaja i just find the same solution 30min ago!

It is not the best solution becasue we need to not put auto de X axis and Y axis but it seems work. 

but i prefer that Microsoft creates a new visual that can do this type of thins, or new features in the scatter plots, or whatever

Thanks a lot!



Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

@PhilipTreacy 

 

I've never used Python visual yet but it's a good occasion to start 🙂

I can give you a sample data but I don't find the button to attach the file to this message and the drag & drop is not working, how do you do that ?

 

Regards,

Cado

PhilipTreacy
Super User
Super User

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.

dots.png

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


@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




Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

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.

Capture d’écran 2021-04-02 104322.png

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
Impactful Individual
Impactful Individual

@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 



Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.