From the course: Power BI Data Visualization and Dashboard Tips, Tricks, and Techniques

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Visualize distribution data with histograms and scatterplots

Visualize distribution data with histograms and scatterplots - Power BI Tutorial

From the course: Power BI Data Visualization and Dashboard Tips, Tricks, and Techniques

Start my 1-month free trial Buy for my team

Visualize distribution data with histograms and scatterplots

“

- [Instructor] A distribution shows how your data is spread or grouped in a meaningful way. Power BI offers some well-hidden solutions to visualize this. There's a scatterplot that doubles as a bubble chart and a bar chart that doubles up as a histogram. So let's take a look. Let's add a new tab and call it Distribution. And we're going to add a scatterplot. I'm going to make it nice and big. I'm still curious about which segment is the most profitable and which are causing problems. So let's put Segment into Legend and then we can put Profit into the Y Axis. Now, we know that Sum of Profit can be a bit misleading. So let's strip out the impact of Units Sold by using Average here instead of Sum. And we can put Units Sold into Size so that we don't lose it. So the larger bubbles here have sold the most units, which we know is government. At a glance, we can see several things already. The circles are all quite similar sizes apart from the government segment, and the highest average…

Contents