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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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