Now, we will put the Owner in Axis and quantity in the Values field.Select the Stacked Column Chart from the visualization section. Here we will map, which salesmen have sold the number of quantities. Let’s create the last chart which is the Staked Column Chart.We have here added the data labels and change the colors from the Fields section of visualization as per our choice. This will give our final Pie chart as shown below.To map the data into Pie Chart, we will drag Product Type and Quantity into Legend and Values as shown below.This will be Pie Chart showing the percentage of the products covering the total share. This is how our map is filled with colors we chose.Here we have selected some different color ranges which may suit our Map.Go to Format, and under Data Color select Conditional Formatting. Similar to the previous table’s conditional formatting, here also we will do the same.We will see, the map is now filled with default colors in each region.Now select the fields Region and Quantity and place them into the Location and Tooltips section to get the proper view on the map.For this, we will select the Filled map chart from visualization. Now let’s insert a region-wise chart where we will map the regions with their sales data.We will see the table data color in quantity column is changed as per the lowest and highest value color we chose.Select the lowest and highest value color as per your choice and then click on Ok.
Click on the drop-down arrow of Quantity from the visualization section and select Background color under Conditional formatting.This will give visualization as shown below.Now will select Month and Quantities under Values as shown below.For this select Table from Visualizations section. Let’s create a table chart first where we will project the monthly sales. Now visualize what you want to see in your dashboard.Here we have renamed that into Dashboard Data. Once data is uploaded we can change the name of the table that we have uploaded in any name if we want.Once we check the box, then click on Load to upload the data in Power BI. Here, the sheet having data is named as Sheet1. Now browse the file location and select the sheet which we want to upload.Here, we have our data in Excel so we have selected the same as shown in thr below screenshot. Then for this, click on Get Data option under the Home menu. If the size of data is huge, as here we have 1000 lines. If the data is less, then we can directly copy the table and paste it in the Enter Data option. There are two ways to upload the data in Power BI. You use the same data and follow the steps or you can have your own data.
You can download this Power BI Dashboard Samples Excel Template here – Power BI Dashboard Samples Excel Templateĭata that we are using have 1000 lines which are sufficient for creating a sample dashboard in power BI.
0 kommentar(er)
