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

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.

Read: Power BI Donut Chart – How to use

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.
Power bi gauge chart
Power bi gauge chart
  • 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.
How to create a power bi gauge chart?
How to create a power bi gauge chart?
  • 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
Power bi gauge chart

Read: Power BI Clustered Column Chart

See also  How to filter SharePoint choice field within Power Apps?

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.
Power bi gauge chart conditional formatting
Power bi gauge chart conditional formatting
  • 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.
power bi gauge chart conditional formatting
power bi gauge chart conditional formatting
  • 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.
Power bi gauge chart conditional formatting
Power bi gauge chart conditional formatting
  • Now you can see the Power bi gauge chart conditional formatting.
microsoft Power bi gauge chart conditional formatting
Microsoft 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.
microsoft Power bi gauge chart conditional formatting
Microsoft Power bi gauge chart conditional formatting
  • 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.
microsoft Power bi gauge chart conditional formatting
Microsoft Power bi gauge chart conditional formatting
  • Now you can see the power bi gauge chart for conditional formatting for target line.
microsoft Power bi gauge chart conditional formatting
Microsoft Power bi gauge chart conditional formatting

Read: Power BI combine columns from two tables

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.
Power bi gauge chart percentage
Power bi gauge chart percentage
  • 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.
Power bi gauge chart percentage
Power bi gauge chart percentage
  • Now you can see the power bi gauge chart percentage of profit.
Power bi gauge chart percentage
Power bi gauge chart percentage

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.
Power bi gauge chart percentage
Power bi gauge chart percentage
  • 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
Power bi gauge chart percentage
Power bi gauge chart percentage

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

Power bi gauge chart percentage
Power bi gauge chart percentage

Read: Power bi create a date table

See also  Power BI MAX and MIN function with Examples

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.
Power bi gauge chart multiple values
Power bi gauge chart multiple values
  • 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 multiple values
Power bi gauge chart multiple values

Read: Power BI Export Data

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.
Power bi gauge chart background-color
Power bi gauge chart background-color
  • 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.
Power bi gauge chart background-color
Power bi gauge chart background-color

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

power bi gauge chart background color
power bi gauge chart background color

Read: Power bi calculated column vs measure

See also  Power Apps Gallery Patch [With Various Examples]

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.
Power bi gauge chart color
Power bi gauge chart color
  • 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")
Power bi gauge chart color
Power bi gauge chart color
  • 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.
Power bi gauge chart color
Power bi gauge chart color
  • Click on the paint icon under visualization, expand the data colors section.
  • Select the conditional formatting “fx” under the fill.
microsoft Power bi gauge chart color
Microsoft Power bi gauge chart color
  • 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.
Microsoft Power bi gauge chart color
Microsoft Power bi gauge chart color

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

Microsoft Power bi gauge chart color
Microsoft Power bi gauge chart color

Read: Microsoft Power BI Combo Chart

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.

Power bi gauge chart with multiple targets
Power bi gauge chart with multiple targets

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
  • >