In power bi, we have many types of visualization techniques and the most important and extensively used one of them is charts, charts are basically used in every report or dashboard to display data to a user, we have inbuilt charts in power bi to use but we 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 things. 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. It is important to know that not all the charts fit into all kinds of data sets, so you need to be choosy while building charts. In this article, we will introduce you to various types of charts in Power BI.
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, and in this article, we will concentrate only on chart visuals.
Copy and paste the data directly to Power BI, or you can copy the data 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 below link, which is used for this example.
#1 – Clustered Bar Chart
The first chart visualization you have in Power BI is the Bar Chart. These are horizontal bar charts that show the graphical representation of the selected category data points. Bar charts are used to 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., select the “Clustered bar chart” and drag the required data in the Value field, as shown below.
The below-Clustered bar chart shows the “Category-wise” number of units sold data.
#2 – Clustered Column Chart
This is the opposite way of the above chart; this power bi chart type shows the bars vertically, whereas “Clustered Bar Charts” shows 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. , select the “Clustered Column chart” and drag the required data in the Value field, as shown below.
The below chart shows the quarterly Sale Value and Cost Value.
#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. is nothing but the combination of two charts, typically “Combination of Column & 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 vs 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 Value field, as shown below.
The below chart shows the “Category-wise Sales Value vs Cost Value.”
From this chart, we easily identify in which category cost is incurring more 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. is an advanced line chart where the area between each data 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 is increased over a period of time or not.
Choose “Area Chart” from visualizations to create an area chart and drag the required data in the Value field, as shown below.
The below chart shows the area between sales value, cost value, and the number of units sold for each category.
#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. comes with no fill color or texture.
The below image shows the difference between the Area chart and 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. shows the portion of each category against the overall value.
To create a Pie chartCreate A Pie ChartThe pie chart is a circular excel chart representing the visualization of data in a circular format. In this circular chart, every category of data has its part, and all the categories make it as a whole circular data., select the “Pie Chart” and drag the required data in the Value field, as shown below.
The below chart shows the “Buyer-wise” total unit’s data point in Pie Chart.
By looking at this Pie Chart, we can identify that “Bruce Curran, Chris Monroe, and Richard Carr” are the buyers who bought a large number of units.
#7 – Doughnut Chart
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. is a kind of pie chart but named as “Donut” because they look like “DOUGHNUT.” Pie Chart shows the full portion where the inner circle is fully occupied, but the Doughnut chart inner circle will not be occupied.
Below two charts show the difference between the Pie Chart and Doughnut Chart.
However, in the doughnut chart, we can play with the inner circle radius under the format section of the chart.
#8 – Funnel Chart
This funnel chartFunnel ChartFunnel charts in Excel are used to represent data behavior at each stage and as the values decrease, the chart takes on the shape of a funnel. This funnel chart feature is only available in Microsoft Office 2019 or later versions. is typically used when the data points are from largest to smallest.
To create a Funnel chart, select the “Funnel Chart” and drag the required data in the Value field, as shown below.
Below, the Funnel chart shows the sales value on buyer-wise.
As you can see above, we have the highest value at the top, second highest below that, and so on.
#9 – Gauge Chart
Gauge ChartGauge ChartExcel's gauge chart resembles a speedometer. It visualizes data with dials and combines two doughnut charts and pie charts. one of the KPI charts to show 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 Targeted value of 100.
Formatting of Power BI Charts
Every chart will be created by default settings, 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 to the right side next to its field area. We can see the format option.
As you can see above, we have a wide variety of formatting options for each chart. We can play with these settings and apply custom touch to the charts.
Note: Power BI dashboard file can also be downloaded from the link below, and the final output can be viewed.
Things to Remember
- Apart from built-in charts, we can also download custom charts from the market place.
- You need to identify what is the best fit chart for your data set.
- Use the formatting section to play with the settings of the chart.
Guide to Power BI Charts. Here we discuss the top 9 types of chart visualization present in Power BI along with the step by step examples. You may learn more about Power BI from the following examples –