Power BI – Create a Radial Gauge Chart

A radial Gauge chart looks similar to a speedometer of a Car. A gauge chart is a half-circle chart, which tells whether a target is achieved or not. Gauge charts are generally used to measure the progress toward a goal. In this article, we will learn how to create a radial gauge chart in Power BI. 

Creating a Radial Gauge Chart 

A Radial Gauge chart has a semi-arc to show its data value. We will take a look at each of the options in the radial gauge chart. For example, we are given a data set of Employees, and we want to make a radial gauge chart, consisting of a set target value, minimum value, and maximum value. We will explore each option while creating this gauge chart. 

The following are the steps:

Step 1: Given the dataset, Employee. The dataset comprises 9 columns. But for understanding the gauge chart, we will be using only two columns i.e. Projects Completed, and Targetted Projects. 

Step 2: Under the Visualizations section, click on the Radial gauge chart. 

Step 3: An empty gauge chart is created. This chart does not contain any fields. Our next task is to add columns to it. 

Step 4: Adding Value in the gauge chart. Drag and drop Projects Completed into the Value. We can see a gauge chart has been created, with the blue portion showing the total sum of the projects completed. By default, the minimum value of a gauge chart is 0, and the maximum value of a gauge chart is twice the sum of the Values. In the below example, 0 is the minimum value, 61 is the sum of Projects Completed, and 122 is the maximum value. We can observe 122 is the double of 61. 

Step 5: What if we want to add a custom minimum value in the gauge chart? This task can be achieved by manually entering the data, or by a pre-defined field. If you have a pre-defined field, then simply drag and drop that field into the Minimum value, else, we can create our own custom column, and can assign it a value. Go to the Measure tools, under, the Calculations section, click on the New measure option. A function bar appears. Now, write the name of the column, with the minimum value you want to assign. For example, Minimum Projects = 10, where Minimum Projects is the column name, and 10 is the minimum value. 

Step 6: We can see that a new measure name, Minimum Projects is added in the Fields section. Drag and drop Minimum Projects into the Minimum value. We can observe that the minimum value of the gauge chart, is changed to 10. 

Step 7: Our next step is to add a maximum value for the gauge chart. Repeat Step5, to add a new column for setting the maximum value into the gauge chart. For example, type Maximum Projects = 125 into the function bar, where Maximum Projects is the column name, and 125 is the maximum value that we want to assign. 

Step 8: We can see that a new measure name, Maximum Projects is added in the Fields section. Drag and drop Maximum Projects into the Maximum value. We can observe that the maximum value of the gauge chart, is changed to 125. 

Step 9: We can set a target value, which is shown by a line on the gauge chart. Drag and drop Targetted Projects into the Target value. A line at 76 is set in the gauge chart. 

Step 10: Our next task, is to add Tooltips in the gauge chart. Tooltips provide additional information that we want to see, whenever we hover at a data point. In the below image, we can see that, we have hovered at the Projects completed portion, and then we can view only the number of projects completed, and the number of targetted projects.  Now, think what if we want to add Bonus to this list? 

Step 11: Drag and drop Bonus under Tooltips. Now, again hover over the blue portion. We can see that Bonus have been added to the list. We have successfully created a gauge chart in Power BI.