Gauge Chart in Power BI – How to Create & Use

Do you want to learn how to create and use a Gauge chart in Power BI?

In this Power BI tutorial, we will learn what a Power BI gauge is, when to use a gauge in Power BI, and how to create a Power BI gauge chart. We will also see how to use the Power BI gauge multiple values.

This tutorial will cover the below topics:

• How to add target value in gauge Power BI
• Power BI gauge chart with max value
• Power BI gauge percentage
• Power BI gauge show percentage and value
• Power BI gauge dynamic target value
• Power BI gauge chart with multiple targets

Gauge Chart in Power BI

Power BI gauge chart is a visualization used for performance management. It shows the current, minimum, and maximum values in comparison to the target value.

When to use gauge chart in Power BI

Power BI gauge charts indicate progress toward a specific goal and allow one to understand the extent to which a target has been reached. They are frequently used to display key performance indicators (KPIs), including sales, labor productivity, and profits.

How to create a Gauge chart in Power BI

Here, we will see how to create a gauge chart in Power BI.

For example, we have the Lead table, as shown below; using this table, we will create a gauge chart in Power BI.

• Open Power BI Desktop loads the data using the Get Data option.
• Then, select the Gauge chart from the visualization pane.
• You can see the blank gauge chart in the Power BI canvas.

Then, drag and drop the Lead value to the Value field. The Power BI gauge chart shows the total lead value.

How to add target value in gauge Power BI

To add the target value the above gauge chart in Power BI.

For this, drag and drop the Target value is added to the target value field. Now, you can see the Power BI gauge chart with a needle, which shows the target leads value.

Power BI gauge chart with max value

Here, we will see how to set the max value in the Power BI gauge chart.

For example, we will take the Lead table and create a gauge chart showing the maximum value.

• In Power BI Desktop, create a gauge chart from the visualization pane.
• Then drag and drop the Lead value, Max value, and target value to the Value, Maximum value, and Target value field
• You can see the gauge chart in Power BI is showing the total max value.

Note:

By default the Power BI gauge chart, minimum value is set to 0 and the maximum value is set to double of value, i.e. Value =10 then Max value =20.

Power bi gauge shows the percentage

Here, we will see how to show the percentage in the Power BI gauge chart.

In this example, we will use the same Leads table and calculate the lead conversion rate percentage. Then, the Power BI gauge will show the percentage.

To show the percentage in the gauge chart, follow the below steps.

• In Power BI Desktop, Load the data using the Get Data option.
• Then click on the New measure, and write the below measure in the formula box:

ConversionRate = 
DIVIDE(
    COUNTROWS(FILTER(Leads, Leads[Lead Status] = "Converted")),
    COUNTROWS(Leads)
)

Next, select the Conversion rate, go to the Mesure tools -> and select the Format type as a percentage.

• Next, select the gauge chart from the visualization pane, then drag and drop the ConversionRate to the value

Power BI gauge show percentage and value

Here, we will see how to show percentage and value in the Power BI gauge visual.

In this example, we will take the Leads table and calculate the total Leads value and Target achievement percentage. Then, we will create a gauge chart in Power BI to show the total Leads value and Target achievement percentage in the Callout value.

Follow the below steps to show the percentage and value in the Power BI Gauge chart

• In Power BI Desktop, load the data using the get data option.
• We will create 2 measures for Target Achievement percentage and TargetAchivement% | Total Lead(to show the percentage and value).

% of Target = 
    DIVIDE (
        SUM(Leads[Lead Value]),
        SUM(Leads[Target Value])
    )

TargetAchivement% | Total Lead = FORMAT([% of Target], "0.0%") & "|" &
FORMAT(SUM(Leads[Lead Value]) & "M", "0.0")

• Once you create the measure, select the ‘%of Target’ measure, open the Measure tool tab, and format it as Percentage.

• Select the gauge chart from the visualization pane. Then drag and drop the Lead value, Min value, Max value, and Target value to Value, Minimum value, Maximum value, and Target value, respectively.

• Click on the Format pane and expand the Callout value. Toggle on the Custom label, click on Add data label, and select the ‘TargetAchivement% | Total Lead’ measure.

Now, you can see the percentage and value in the Power BI gauge visual.

Power BI gauge chart dynamic target value

Here, we will see how to implement the dynamic target value in the Power BI gauge chart.

For example, we will use a Leads table to create a gauge chart in Power BI. Then, we will use the Lead source slicer to change the target value dynamically in the Gauge chart.

• In Power BI Desktop, load the data using the Get Data option.
• To create a gauge chart, select the gauge chart from the visualization pane.
• Then, drag and drop the Leads value, target value, and max value columns to the Value, Target value, and Maximum value fields.

• To change the target value dynamically, select the Slicer visual from the visualization pane.
• Then, drag and drop the Lead source column into the Field.

Now, if you select the Lead source from the Slicer, the target value dynamically changes in the Gauge chart.

Power bi gauge chart with multiple targets

Here, we will see how to show multiple targets in the Power BI gauge chart.

As in the Power BI gauge chart, we cannot set multiple targets to show the actual value and target value.

So, we have a workaround for showing the actual value [blue fill] and the target value [orange fill] in a Power BI gauge chart.

For this, follow the below steps to show multiple targets in the Power BI gauge chart.

• In Power BI Desktop, select the gauge chart from the visualization pane.
• Then drag and drop the Target value, Min value, and Max value to The Value, Minimum value, and Maximum value.
• Then click on the Format pane, toggle off the Data label and Callout value, and change the Fill color in the Color section.
• Next, click on the General tab here, expand the Effect section, and make transparency 100%

• Create another Power BI gauge chart from the visualization pane.
• Then, drag and drop the Lead value, Min value, Max value, and Target value to The Value, Minimum value, Maximum value, and Target value fields.
• Next, go to the Format pane and click on the General tab, expand the Effect section, and make the background Transparent 100%.

Then, drag the first gauge chart and place it under the second gauge chart in Power BI canvas. So, it will look something like below

• Select the View tab, and from there, select the selection pane to group both visuals so they act like one.
• In the Select pane, select both visuals and click on the More icon -> select Group -> Group.

Now, the gauge chart shows two values, i.e., actual value and target value.

This is an example of a gauge chart with multiple targets in Power BI.

Also, you may like some more Power BI articles:

• Conditional Formatting in Power BI Gauge Chart
• Donut Chart in Power BI
• How to Create and Use Power BI Combo Chart
• Power BI Combine Two Tables With Same Columns
• Horizontal Funnel Chart in Power BI
• How to Set as Total in Power BI Waterfall Chart

Conclusion

In this Power BI tutorial, we saw what a gauge chart is and how to use it.

Also, we saw how to set target value and max value in the Power BI gauge chart. Moreover, we have covered some of the examples:

• Power BI gauge show the percentage
• Power BI gauge show percentage and value
• Power BI gauge dynamic target value
• Power BI gauge chart with multiple targets

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.