Scatter Plot: Power BI Vs Excel

[AlbertLotito]

Good day all,
I am newish to Power BI but have been using computers since the TRS-80 Model 1 with 4kb of RAM.
And I have been using office since the MS-DOS days.
SO.. What am I missing here (see below)?

Thanks in advance for reading this post, and hopefull giving me some insight!

I have a data set, 2 columns

• Column A: Date time, oldest to newest. (The x axis)
  This column, named 'ActualStartTime' is in the format yyyy-mm-dd hh:mm.
  
  
• Column B: a numeric value. (The y axis)
  
  

About 4750 lines of data. 

for refrerence, the data spans 4 weeks (the pattern of weekday vs weekend becomes apparent in the excel chart)

In Excel, when creating a scatter plot I see the entire data set. That is to say, excel displays the full series along the X-Axis, visualizing the full data set in one chart.

In Power BI, with the same data I get a slider control at the bottom, which defeats the purpose of showing the patterns.

Additionally, Power BI will not accept an X-Axis which is TIME AND an unsummarized  Y-Axis, which Excel handles with grace.

What am I missing???
This seems like a very basic thing that Excel mastered decades ago...
Am I doing it 'Wrong'?

Link to Data: Data Set ( PWD: Freedom-Dancing4495# ) 

See Screen shots:
Excel:

Power BI
With summarized Y-Axis:

With Unsummarized Y-Access:

Best,
Albert Lotito.

[radhey_rec]

Hi @AlbertLotito ,

I am not sure, if this can be done with native Power BI visuals. Let the experts comment about it.

If you find that Power BI native visuals are not able to help you with, Microsoft has generously provided its marketplace  at appsource.microsoft.com to enrich functionality of its products. There you can find multiple custom visuals that can help you with.

One such visual that I feel may be helpful to you could be bubble chart . Please give it a try.

Thanks,

-Radhey

[AlbertLotito]

Hello,

Thankyou for the suggestion.

I have tried the Bubble Chart and the problmes are the similar. 

I have also tried the 'High Density' Option.
I also tested various scatter plots from the market place, with similar results.

It is very frustrating that this is a problem Microsoft solved more than a decade ago in Excel, but can not bring the same solutino to Power BI.


Thanks,

Albert.

[radhey_rec]

Hi @AlbertLotito ,

Please send me a sample pbix file and let me try it for you. If I gain success, I shall let you know (tomorrow).

Shared data link requires a password which I do not have.

[AlbertLotito]

Thank you for offering to work on it. 
Find a ZIP file  at the included link.
Sample File with Data 

Best,

Albert

[radhey_rec · Accepted solution]

Hi @AlbertLotito 

I have managed to make the chart as expected with the help of Bubble Chart with Categorical Data (Pro) 

Here is the result:

Please find the update pbix file:

Updated Sample file link 

Thanks,

-Radhey

[AlbertLotito]

WOW!!! Most Boudacious!
Thank You, looking now at how you did it!!!