# Power bi gauge chart – How to use with examples

In this power bi tutorial, we will discuss the power bi gauge chart. And also we will discuss the below points:

• When to use Gauge chart in power bi?
• How to create a power bi gauge chart?
• Power bi gauge chart conditional formatting
• Power bi gauge chart percentage
• Power bi gauge chart multiple values
• Power bi gauge chart background-color
• Power bi gauge chart color (dynamically)
• Power bi gauge chart with multiple targets
At A Glance - Here's what we'll cover:

## What is a power bi gauge chart?

• The power bi gauge chart is used to show the progress toward a particular goal
• It shows the minimum, maximum, and current value against the targeting value.
• Power bi gauge chart is often used to represent KPI (Key performance indicator), such as sales, profits, or revenue.

## When to use Gauge chart in power bi?

Let’s see When to use the Gauge chart in power bi.

The Gauge chart is the perfect choice:

• When you want to show progress towards a goal in power bi
• When you want to represent a percentile measure like a key process indicator.
• When you want to show the health of a single measure in power bi
• When you want to display the information you can quickly scan and understand it.

## How to create a power bi gauge chart?

Here we will see how to create a power bi gauge chart by using the sample data in power bi desktop.

• Open your power bi desktop.
• Load the data using get data from the ribbon.
• Select the Gauge chart from the visualization.
• In the field formatting section, under the values drag and drop the Gross sales from the Field pane in power bi desktop.
• Then change the aggregation to average from the dropdown.
• Now we will add the target value, in the target value drag and drop the COGS column from the Fields pane.
• From the drop-down change the aggregation to the average of COGS.
• Now you can see the power bi gauge chart based on values (average) and target values(average).
• Here the power bi gauge chart, line is represented as target values, and the shading is represent progress toward the goal.

## Power bi gauge chart conditional formatting

Here we will see about power bi gauge chart conditional formatting in power bi desktop.

• In power bi desktop, select the gauge chart from the visualization.
• In the value, the field adds the Gross sales column from the field pane.
• In the target value field adds COGS column from the field pane.
• Go to the Format section in the visualization pane. Then expand the data colors section.
• Here you can apply conditional formatting to fill and target line of the gauge visualization.
• To apply conditional formatting in gauge fill, Click on the ‘fx’ icon.
• Now fill conditional formatting dialog box open, under Format by select color scale.
• Under Based on field, select the field i.e. Gross sales, and under summarization select minimum
• Then add custom value for the minimum is 120000 and add custom value for maximum is 145000.
• If you want to add the middle color then select the diverging, then you can add the custom value for the middle. Click on OK.
• Now you can see the Power bi gauge chart conditional formatting.
• Now we will add conditional formatting to target line. To add Conditional formatting Click on the ‘fx’ under the Target.
• Conditional formatting window will open, and under format by select color scale.
• Then under Fields select field i.e. COGS and under summarization select Average
• Then add the custom value for minimum i.e. 120000, and for maximum i.e. 146000.
• Now you can see the power bi gauge chart for conditional formatting for target line.

## Power bi gauge chart percentage

Here we will see about power bi gauge chart percentage in power bi desktop using the sample data.

• In power bi desktop, select the gauge visualization.
• Then for the value field drag and drop the profit column from the Field pane.
• Click on the profit column in the field pane, it will take you to the Column tools tab.
• In Formatting Section, next to the format change it to percentage.
• Now you can see the power bi gauge chart percentage of profit.

Let’s see how to set power bi gauge percentage for the target line.

• Select the gauge chart from the visualization.
• Then drag and drop the COGS field and profit field from the Field pane to the value field and target value field respectively in the field format section under visualization.
• Then change the aggregation to average from the field drop-down for both the field in the Field format section.
• Click on the profit column, it will take you to the column tools, where you can change the format of data to percentage.
• Ensure that the column you will change the format of data to a percentage should be added to the target value field.
• Change the Format to the percentage for profit in the formatting section

Now you can see the power bi gauge chart show percentage.

## Power bi gauge chart multiple values

Here we will see power bi gauge chart multiple values

• In power bi desktop, select gauge chart from the visualization.
• Then drag and drop COGS field and Gross sales from the Field pane to the Value field and target field respectively
• Multiple values are not supported in the value field of the gauge chart in the power bi desktop.
• To show multiple values on the visualization, we will use a tooltip field.
• Where we can add multiple fields when you hover over the gauge visualization it will show the multiple values.
• Drag and drop unit sold and profit from the field pane to the tooltip field under visualization in power bi desktop.
• When you hover over the gauge chart visualization, it will show the multiple values.
• In the below screen-shot, you can see the power bi gauge chart multiple values.

## Power bi gauge chart background-color

Here we will see about power bi gauge chart background color by using the sample data.

• In power bi desktop, select the power bi gauge chart.
• Then drag and drop the profit field from the field pane to the value field.
• Then click on paint icon, under visualization. Expand the background color section.
• Select the color, under color. Then choose a color from the color pane.
• And also you can set the conditional formatting for background color, the background will change according to value.

In the below screenshot you can see the power bi gauge chart background color.

## Power bi gauge chart color (dynamically)

Here we will set dynamically power bi gauge chart color in power bi desktop using the sample data.

• Open power bi desktop.
• Click on the new measure from the ribbon in power bi desktop.
• Now we will add the Dax formula, which will change the color dynamically by using Switch(). You need to use your measure name like [Total sales]
• Dax formula is:
``Gauge color = SWITCH( TRUE(), [Total sales]>80000000,"Yellow",[Total sales]>119000000,"Green","Red")``
• Now select the gauge chart from the visualization in power bi desktop.
• Then drag and drop the Total sales( measure) and gross sales to the value and target field respectively to the Field format.
• Click on the paint icon under visualization, expand the data colors section.
• Select the conditional formatting “fx” under the fill.
• Now conditional formatting window will open, under Format by select Field.
• Then under based on Field, select the Gauge color( Dax formula). Click on ok.

In the below screenshot you can see the power bi gauge chart color( dynamically)

## Power bi gauge chart with multiple targets

Here we will discuss the power bi gauge chart with multiple targets.

In the power bi desktop, the built-in gauge chart(radial gauge chart) doesn’t have a feature to show the multiple targets.

Instead of that, you can use the Advanced gauge chart or dial chart, you can download it from the Custom visual App source in power bi desktop.

You may like the following Power BI tutorials:

In this power bi tutorial, we discussed the Power bi gauge chart. And also we discussed the below points:

• When to use Gauge chart in power bi?
• How to create a power bi gauge chart?
• Power bi gauge chart conditional formatting
• Power bi gauge chart percentage
• Power bi gauge chart multiple values
• Power bi gauge chart background-color
• Power bi gauge chart color (dynamically)
• Power bi gauge chart with multiple targets
• Bryan says:

Percentage gauges make no sense. Why does 1600% fit within 0 and 100%?

• Bijay Kumar says:

Hi Bryan,
Thanks for your comment on this. It was just to show the background color, anyways I have corrected the image.