Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
When I start analyzing a one-dimensional set of data, the first thing I do is always to look at ALL THE DOTS of the population.
And if I want to analyze time variation I want to see all the dots with date on the X-axis and measured value on the Y-axis
This dot plot with individual values is the most basic graph in excel, and the most usual graph in media, see for instance below, an example of poll results over time, with all the polls as individual dots and moving average as a continuous line
How can this basic of the basics not be available in PowerBI ?
we have zillions of fancy graphs with more or less usefull features at hand, and not the one everybody should start with
what is wrong in developing this diagram ?
You mean the Scatter plot chart?
Yes, the correct english wording is probably scatter chart. I may have been misled by the french designation "nuage de points"
However, the key point is that all engineers all taught to first look at their data, and start plotting the individual values to vizualize the population. Then they add some lines characterizing variation, such as in the classical control charts of SPC.
This is really a big, big, lack in the default visuals of Power BI. Customers from the engineering community will want to see SPC charts, in particular because the quality system asks for it.
Regards
Hey,
unfortunately, this is not possible using the default visuals, if you are familiar with R this link might be helpful:
http://library.open.oregonstate.edu/computationalbiology/chapter/plotting-data-and-ggplot2/
If you are more on the python side, then this maybe helpful: https://python-graph-gallery.com/scatter-plot/
Be aware that not all python packages that you are used to use are also supported in combination with Power BI service, this link lists the currently supported python packages (since the February 2019 release).
Hopefully, this helps a little,
Regards,
Tom
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |