python visual: Scatter Plot 2 sets of data points

[niyati_61]

Hello,

I used a Python Visual to make the Scatter Plot Chart below, however the X-Axis is not visible? 

The X-Axis has a lot of Date Time Data (Eg: 2021-10-04 07:57:40). However it is just showing as a blank black line.

Black Points Marked (Measured) 

Also, how do I add another set of data points to this graph? Red Points (For Simulation) But that will be against another X and Y axis. I require it in the same scatter plot chart.

Thank you!

[niyati_61]

Hi @YukiK ,

Thanks for replying, appreciate it!
Actually the color of the data points is not the issue here. And yes, I did try streching the visual to its max size, and I used the formula too however my x-axis is not visible still. 

Okay, let me explain exactly what I require. 

Currently I'm working with CSV data, 2 Files as shown below, 

Measured Data

Simulation Data

I want to make a scatter plot chart using a python visual. 

Imp Note: The measured CSV File has around 8k rows,

and the simulation CSV File has around 1.5k rows.

They are not plotted against the same exact times. The reason why Simulation has less points is that, once the Measured is marked on the chart, the simulation data points cover from the beginning to the end like overall.

So bascially for both of these, we need to use all the 4 axes.

This is what I finally want, 

I tried it in Power BI, I can get the Measured points in one chart (Like I have shown here), and similarly Simulation points in another chart. 

But, how do I combine the 2 together in one chart like this one?

Kindly require your assistance asap. Thank you in advance!

[YukiK]

I'm guessing the issue is in your Python code. You can specify color like this (if using matplotlib):

plt.scatter(x, y, color = 'hotpink')

As far as the x-axis goes, I think the size of the visual is simply small for the number of values that need to be shown. So if just making the visual bigger in Power BI doesn't work, try have it wider in matplotlib like this:

figure(figsize=(20, 8))

Let me know if this helps!