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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AlbertLotito
Regular Visitor

Scatter Plot: Power BI Vs Excel

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:

AlbertLotito_0-1683622901735.png

 

Power BI
With summarized Y-Axis:

AlbertLotito_4-1683624117722.png

 

With Unsummarized Y-Access:

AlbertLotito_5-1683624146747.png

 

Best,
Albert Lotito.

 

1 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:

radhey_rec_0-1683783658452.png

Please find the update pbix file:

Updated Sample file link 

 

Thanks,

-Radhey

View solution in original post

6 REPLIES 6
radhey_rec
Resolver II
Resolver II

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

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.

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.

radhey_rec_0-1683649742765.png

 

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

 

Best,

Albert

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:

radhey_rec_0-1683783658452.png

Please find the update pbix file:

Updated Sample file link 

 

Thanks,

-Radhey

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.