Power BI Visuals

Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What are Power BI Visuals?

Power BI has some built-in visuals and custom visuals for data visualization. Custom visuals are user-defined where the user can use creativity to present data. For example, we can use lines and dots flashing and floating to display the data changes in a certain time period.

Power BI visuals are the type of charts, graphs, tables, cards, etc., available with Power BI to visualize our data.

Power Bi Visuals

Power BI visuals are the type of charts, graphs, tables, cards, etc., available with Power BI to visualize our data.

In this Power BI visualization box, we can see “Stacked Bar ChartStacked Bar ChartThe stacked bar chart in Excel represents data in the shape of bars, with the bars representing different segments or categories for comparison. A stacked bar chart is used to compare different types of data in terms of their values.read more, Stacked Column ChartStacked Column ChartA stacked column chart in Excel is a column chart where multiple series of the data representation of various categories are stacked over each other. The stacked series are vertical.read more, 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, Clustered Bar ChartClustered 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, 100% Stacked Bar Chart, 100% Stacked Column Chart, 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, Area ChartArea ChartThe 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, Stacked Area Chart, Line & Stacked Column Chart, Line & Clustered Column Chart, Ribbon Chart, Waterfall Chart, Scatter ChartScatter ChartScatter plot in excel is a two dimensional type of chart to represent data, it has various names such XY chart or Scatter diagram in excel, in this chart we have two sets of data on X and Y axis who are co-related to each other, this chart is mostly used in co-relation studies and regression studies of data.read more, Pie ChartPie 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, Donut Chart, Treemap, Map, Filled Map, 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, Gauge ChartGauge ChartExcel's gauge chart resembles a speedometer. It visualizes data with dials and combines two doughnut charts and pie charts.read more, Card, Multi-row Card, KPI, SlicerSlicerSlicers are a handy feature in excel to use multiple auto filters in a data table. However, it involves many clicks to use a filter on every column to find a date. A slicer makes it easier as it can be done with a few clicks.read more, Table, Matrix, etc.

Now, we will see how to use some of these visuals and format the same for better visualization.

Power-BI-Visuals

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 Visuals (wallstreetmojo.com)

You can download the Excel data below to use the same for building visuals. However, it is better if you can download and practice with us as we show them.

You can download this Power BI Visuals - Excel Template here – Power BI Visuals - Excel Template

–>> 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.

How to Create Custom Visuals in Power BI?

We have already uploaded the data from Excel to Power BI, which looks like this.

data from excel to power bi visuals

So, the first Power BI visual we will practice is “Cards.”

Visual #1 – Cards

Cards are there to showcase the selected column numbers. Now, we will show how many responses are in this employment survey.

For this, first, choose the “CARD” visual.

Power BI Visual #1 - Card

Choose the “Rows” column from the “Fields” to get the total responses.

Visual #1 - Card (Rows)

Since the cards are the current selection, we can easily see the numbers on the card. But the moment you unselect the card, it looks like the one below.

Visual #1 - Card (unselect)

In this, we cannot see a card visual for this, so now we need to design this visualization to improve the presentation.

  • First, we will add a heading for this card because, as of now, we do not see any heading for this card. Select the card and go to the formatting section.
Visual #1 - Card (field)
  • Click on “Format” in this section to see all the formatting options.
Visual #1 - Card (format)
  • Since we need to add “Title” to the card, click on the “Title” option. Under this, enter the “Title” of the card as “Total Responses,” font color as “Black,” background-color as “Pink,” alignment as “Center,” “Text size” as “20,” “Font family” as “Verdana.”
Visual #1 - Card (format options)

Now, we will have a card heading like the below one.

Visual #1 - Card (Heading)
  • Since we have added “Title” to the card, make “Category label” “Off.”
Visual #1 - Card (Category label)
  • Now, choose the background option and fill the color identical to the title background color.mak Also, make the transparency 50%.
Visual #1 - Card (Background color)
  • Now, apply “Border” to the card, as shown below.
Visual #1 - Card (Border)

Visual #2  – Donut Chart

We all know how to create a Donut chart in Excel, but this time in Power BI visuals, you need not break your sweat, so for the data on “Education and their respective salaries,” we will create a “Donut” chart.

  • Select the “Donut chart” first.
Power BI Visual #2 - Donut Chart
  • Now, click on “Education” and “Salary USD” from the “Fields” column from the “Fields” column to create a donut chart.
Visual #2 - Donut Chart (education & salary)

Similarly, we must play around with this chart to make it look beautiful.

  • Add “Border” to the chart, as shown below.
Visual #2 - Donut Chart (Border)
  • Now, add background color, as shown below.
Power BI Visual #2 - Donut Chart (Background color)
  • You can change the “Title” of the chart and make formatting, as shown below.
Power BI Visual #2 - Donut Chart (Title Text)
  • Switch off “Data labels.”
Power BI Visual #2 - Donut Chart (Data Label)
  • Add “Legend.”
Power BI Visual #2 - Donut Chart (Legends)
  • For “Legend,” do the below formatting to make it look beautiful.
Power BI Visual #2 - Donut Chart (legend formating)

If you wish to play around with the inner circle size of the donut chart, you can do this under “Shapes.”

  • The inner circle will look like the “Pie” chart if the inner radius is zero.
Power BI Visual #2 - Donut Chart (Shapes)

Like this, you can increase or decrease the inner circle size to fit.

Visual #3 – Table

Using Table visual, we can create a summary table. For example, if you want to create a summary of “Job Title,” a wise number of responses, choose “Table” from visuals.

Power BI Visual #3 - Table

Now, choose “JobTitle” and “Rows” from the “Fields” to create a table like this.

Visual #3 - Table (Fields, Job Title & Rows)

Add “Title” to the chart as “Job Title-wise Responses Summary” and design the heading.

Power BI Visual #3 - Table (chart design)

Like this, we can create Power BI visualizations to design the dashboards.

Things to Remember

  • Based on the data, we can design the visuals.
  • We can insert custom visualization in Power BI as well.
  • For all the visuals, formatting is an important technique. We must learn formatting methods to add value to the dashboard.

Recommended Articles

This article is a guide to Power BI Visuals. Here, we learn how to create custom visuals with Microsoft Power BI and examples of cards, donut charts, tables, etc. You can learn more about data visualization from the following articles: –