Looking to learn how to create a scatter plot in Power BI? In this tutorial, we'll walk you through the steps to build a scatter plot in Power BI using the example of displaying dots for categories in regions, based on the sum of profit and sum of sales.
To get started, simply click on the scatter plot option and bring in two measures - sales and profit. Initially, you'll see only one dot, but you can make it bigger and split it up by bringing region onto the legend. This will give you four dots, one for each region.
You can also size the dots by adding another measure, such as sales, to the size field. The larger the dot, the higher the sales.
To further refine the scatter plot, add more dimensions like category to the value shelf. The more dimensions you add, the more dots you'll get. And if you add product under category, you'll see even more dots based on all the available products in your data.
With these simple steps, you'll be able to create a customized scatter plot in Power BI for your data analysis needs.
How do you build a scatter plot in power bi in this example I have sum of profit and sum of sales and I'm showing dots for categories in regions let's take a look at how to build that in power bi first click on the scatter plot option and we're going to bring two measures in this case I'm going to bring in sales and profit. You see that we only get one dot let's make it bigger
And start splitting up this Dot if I bring region onto Legend it's going to give me four regions four dots one dot for each region you can also size by a measure let's bring sales onto size as well and the dot is larger the more the sales are you can keep splitting these dots up by bringing more Dimensions like category onto the value Shelf the more Dimensions you add to the value shelf the more dots you get if I add product under category intro down to the bottom we're going to have a lot of different dots based on all the products available in the data.
24 авг 2024
