Power BI Charts

Updated on January 2, 2024
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

In Power BI, we have many types of visualization techniques. The most important and extensively used one of them is charts. Charts are used in every report or dashboard to display data to a user. We have built-in Power BI charts to use but can also make combo charts or custom-made charts.

Chart Visuals in Power BI

While creating the Power BI dashboard chart, visuals are the most eye-catching. Charts are better suited for any dashboard with numerical data sets but knowing about the in and out of the chart is necessary to create the right kind of chart type for the data sets. In addition, it is important to know that not all charts fit into all kinds of data sets. So, it would be best if you were choosy while building charts. In this article, we will introduce you to various types of charts in Power BI.

Power-BI-Charts

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Power BI Charts (wallstreetmojo.com)

Top 9 Types of Charts Visualization in Power BI

When you look at the visualization gallery of Power BI, you will see plenty of visual types. However, in this article, we will concentrate only on chart visuals.

Copy and paste the data directly to Power BI. Else, you can copy it to an Excel file and then import it to Power BI as an Excel file reference. So, you can download the Excel workbook template from the link below, which is used for this example.

You can download this Power BI Charts Excel Template here – Power BI Charts Excel Template

#1 – Clustered Bar Chart

The first chart visualization you have in Power BI is the bar chart. These horizontal bar charts show the graphical representation of the selected category data points. For example, bar charts show the number of units sold, the sale value of different categories, etc.

To create a Clustered bar chartCreate A Clustered Bar ChartA clustered bar chart represents data virtually in horizontal bars in series, similar to clustered column charts. These charts are easier to make. Still, they are visually complex.read more, select the “Clustered bar chart” and drag the required data in the “Value” field, as shown below.

Power BI Charts - Clustered Bar Chart 1

The below-clustered bar chart shows the category-wise number of units sold data.

Power BI Charts - Clustered Bar Chart 2

–>> If you want to learn Power BI professionally, then Power BI Basics Course (5+ hours) is the perfect solution. This course will introduce you to a wide range of Power BI concepts like collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights, Creating Reports in Power BI Desktop, Analyze Data with Excel, Graphs & Visualizations, Interactive Dashboards along with some real life examples.

#2 – Clustered Column Chart

It is the opposite of the above chart. This Power BI chart type shows the bars vertically. Whereas “Clustered bar charts” show the bars horizontally.

To show a Clustered Column chartClustered Column ChartIn Excel, a clustered column chart depicts data in a series of vertical columns. Though these charts are simple to create, analyzing them becomes increasingly difficult as the number of categories increases from single to multiple. read more, select the “clustered column chart” and drag the required data in the “Value” field, as shown below.

Power BI Charts - Clustered Column Chart

The below chart shows the quarterly “Sale Value” and “Cost Value.”

Power BI Charts - Clustered Column Chart 1

#3 – Combo Chart

The combo chartCombo ChartExcel Combo Charts combine different chart types to display different or the same set of data that is related to each other. Instead of the typical one Y-Axis, the Excel Combo Chart has two.read more is nothing but the combination of two charts, typically a combination of “Column Chart” and “Line Chart” to show different data points where we can compare one data point against the other data point.

For example, if you want to compare monthly “Sales Value” and “Cost Value,” then we can use this combo chart to plot our data points.

To make a combo chart, select the “Line and stacked column chart” and drag the required data in the “Values” field, as shown below.

Power BI Charts - Combo Chart 1

The below chart shows the category-wise “Sales Value” vs. “Cost Value.”

Power BI Charts - Combo Chart

This chart easily identifies which category cost is increasing even though sales are on the higher side.

#4 – Area Chart

An area chart in excelArea Chart In ExcelThe area chart in Excel is a line chart that shows the impact and changes in various data series over time by separating them with lines and presenting them in different colors. The line chart is used to create this graph.read more is an advanced line chart where the area between each data and different line items is filled with color, pattern, or texture. An area chart is used to show what is the gap between one data point to another data point and make some decisions in terms of whether the sale increased over some time or not.

Choose “Area chart” from visualizations to create an area chart and drag the required data in the “Values” field, as shown below.

Power BI Charts - Area Chart

The below chart shows the area between sales value, cost value, and the number of units sold for each category.

Power BI Charts - Area Chart 1

#5 – Line Chart

An area chart is filled with some color or texture between one data point to another data point, but the line chartLine ChartLine Graphs/Charts in Excels are visuals to track trends or show changes over a given period & they are pretty helpful for forecasting data. They may include 1 line for a single data set or multiple lines to compare different data sets. read more comes with no fill color or texture.

The below image shows the difference between the area chart and the line chart.

Power BI Charts - Area vs Line Chart

#6 – Pie Chart

We all know this chart in excel, in Power BI too, it works similarly. Power BI Pie ChartPower BI Pie ChartA pie chart in Power BI is a built-in visualization chart. It is a round-shaped circle where each category data set is shown in a pie shape based on the value of each data label. Each category is adjusted against the overall portion of the data labels.read more shows the portion of each category against the overall value.

To create a Pie chartCreate A Pie ChartMaking a pie chart in excel can help you with the pictorial representation of your data and simplifies the analysis process. There are multiple kinds of pie chart options available on excel to serve the varying user needs.read more, select the “Pie chart” and drag the required data in the “Values” field, as shown below.

Pie Chart Formatting

The below chart shows the buyer-wise total unit’s data point in the pie chart.

Pie Chart

Looking at this pie chart, we can see that “Bruce Curran, Chris Monroe, and Richard Carr” are the buyers who bought many units.

#7 – Doughnut Chart

A Doughnut chartDoughnut ChartA doughnut chart is a type of excel chart whose visualization is similar to pie chart. The categories in this chart are parts that, when combined, represent the whole data in the chart. A doughnut chart can only be made using data in rows or columns.read more is a kind of pie chart named “Doughnut” because they look like “DOUGHNUT.” The pie chart shows the full portion where the inner circle is fully occupied but will not occupy the doughnut chart inner circle.

Below are two charts showing the difference between the pie chart and the doughnut chart.

Pie vs Donut Chart

However, in the doughnut chart, we can play with the inner circle radius under the format section of the chart.

Donut Chart (Formating)

#8 – Funnel Chart

This funnel chartFunnel ChartFunnel charts in excel is similar to its name associated with it, it is used to represent data behavior in every stage defined and as the values go on decreasing thus making the shape of funnel for the chart and so the name of funnel chart, this feature of funnel chart is only available in Microsoft office 2019 or in the latest versions.read more is typically used when the data points are from largest to smallest.

Select the “Funnel” chart to create a funnel chartand drag the required data in the “Values” field, as shown below.

Power BI Charts - Funnel Chart

Below, the funnel chart shows the sales value buyer-wise.

Funnel Chart

As you can see above, we have the highest value at the top, the second-highest below that, and so on.

#9 – Gauge Chart

A Gauge ChartGauge ChartExcel's gauge chart resembles a speedometer. It visualizes data with dials and combines two doughnut charts and pie charts.read more is one KPI chart that shows actual performance against the set targeted value. This chart requires “Target Value” to be given to gauge the actual value against it.

The below chart shows the actual value of 85 vs. the targeted value of 100.

Gauge Chart

Formatting of Power BI Charts

Default settings will create every chart, but we can play around with these settings under the format section of each chart. Once the chart is selected, we can see its field area on the right side next to its field area. We can see the “Format” option.

Power BI Charts - Format option

As you can see above, each chart has various formatting options. We can play with these settings and apply custom touch to the charts.

Note: We can also download the Power BI dashboard file from the link below. We can view the final output.

You can download this Power BI Charts Template here – Power BI Charts Template

Things to Remember

  • Apart from built-in charts, we can also download custom charts from the marketplace.
  • We must identify what the best fit chart for the data set is.
  • We must use the formatting section to play with the chart’s settings.

This article is a guide to Power BI Charts. Here, we discuss the top 9 types of chart visualization present in Power BI, along with step-by-step examples. You may learn more about Power BI from the following examples: –