Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
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
You can add a third column to the Axis or Legend. The result will be different. In my test, I add a Time column.
Hi @Anonymous
You may try some custom Dot Plot visuals. For example Dot Plot by OKViz and Dot Plot by MAQ Software
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!