Power Bi Donut Chart With Total In Center
Introduction
Power BI is a powerful tool that allows businesses to analyze their data and make informed decisions. One of the popular visualizations in Power BI is the donut chart, which presents data in a circular format. However, most donut charts in Power BI do not display the total value of the data, which can be a problem for some users. This article will guide you through the steps of creating a donut chart with the total value displayed in the center using Power BI.
Step 1: Prepare Your Data
The first step is to prepare your data. In this example, we will use a sample data set that contains the sales figures for a company's products. The data set has two columns - Product and Sales. We need to calculate the total sales for all products and add it to our data set. To do this, we can use the following DAX formula:
Total Sales = SUM(Sales[Sales])
After adding the Total Sales column to our data set, we can proceed to create our donut chart.
Step 2: Create the Donut Chart
To create the donut chart, we need to select the Product and Total Sales columns in Power BI. Then, we can go to the Visualizations pane and select the donut chart icon. This will create a basic donut chart.
Next, we need to format our donut chart. We can do this by selecting the Format tab in the Visualizations pane. Here, we can customize various aspects of our chart, such as the colors, labels, and data labels.
Step 3: Add the Total Value to the Center
Now, we need to add the total value to the center of our donut chart. To do this, we can use a custom visual called the Infographic Designer. This visual allows us to create custom images and add them to our charts.
First, we need to download and import the Infographic Designer visual from the Microsoft AppSource. Once we have imported the visual, we can add it to our donut chart by selecting the ellipsis (...) in the Visualizations pane and selecting Add visual.
Next, we need to configure the Infographic Designer visual to display the total value. We can do this by selecting the visual and going to the Format tab in the Visualizations pane. Here, we can upload an image or create a custom image using the visual editor. We can then add a data label to the image and select the Total Sales column as the data source.
After configuring the Infographic Designer visual, we can adjust the size and position of the image to fit our donut chart. We can also customize the font, color, and alignment of the data label.
Conclusion
In conclusion, adding the total value to a donut chart in Power BI can provide valuable insights for businesses. By following the steps outlined in this article, you can create a donut chart with the total value displayed in the center using Power BI. With this visualization, you can easily identify which products are generating the most sales and make data-driven decisions to improve your business.