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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Date in Scatter Chart

Hey! 

 

I try to create a scatter chart, which has several data on the X-axis (e. g. 29. 01. 2024, . . . ) and on the Y-axis a maxCurrent column. However, there are several values to maxCurrent every day (since it was measured at different times). It is all neatly interconnected (date is interconnected). As soon as I want to insert these columns into the corresponding custom scatter chart, it only works if I use the sum or the average or some other aggregate on maxCurrent. However, I want to use it without an aggregate ("don't summarize" button).

 

Can someone help me with this probelm?

 

Important: I want to use the custom scatter chart (not python or R or anything else) because of the Tooltips and Legend.

 

Best regards

Dominic

3 REPLIES 3
Anonymous
Not applicable

Hey Jing

 

The problem with your suggestion is: They just use again an aggregation like summarize or taking the average...

But I want a plot, that shows every single value with a dot. 

 

The plot from MAQ Software is close to my request but it you have also to take a sum or something.

 

But thanks for your suggestion

 

Best Regards,

Dominic

Anonymous
Not applicable

You can add a third column to the Axis or Legend. The result will be different. In my test, I add a Time column. 

Anonymous
Not applicable

Hi @Anonymous 

 

You may try some custom Dot Plot visuals. For example Dot Plot by OKViz and Dot Plot by MAQ Software

vjingzhanmsft_0-1711607919209.png

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Kudoed Authors