Blog

Power BI Visualization Types

  • (4.0)
  •   |   96 Ratings

Visualizations in Power BI displays the visual insights from a data. In power bi service a visual can be pinned from reports to create dashboards. Visuals are used in reports.

Enthusiastic about exploring the skill set of Power BI? Then, have a look at the Power BI Training together additional knowledge. 

Visualizations

List of visualizations available in Power BI

All of these visualizations can be added to Power BI reports, specified in Q&A, and pinned to dashboards.

Area charts: Basic (Layered) and Stacked

Basic Area chart

Example: The Basic Area chart is based on the line chart with the area between the axis and line filled in

Bar and column charts

Bar charts

Column charts

Example: Bar charts are the standard for looking at a specific value across different categories.

Cards: Multi row

Multi Row

Cards: Single number

Single Number

Combo charts

Combo charts

Example: A Combo chart combines a column chart and a line chart. Choose from Line and Stacked Column and Line and Clustered Column.

Doughnut charts

Doughtnut charts

Example: Doughnut charts are similar to Pie charts.  They show the relationship of parts to a whole.

Funnel charts

Funnel charts

Example: Funnels help visualize a process that has stages and items flow sequentially from one stage to the next.  Use a funnel when there is a sequential flow between stages, such as a sales process that starts with leads and ends with purchase fulfillment.

Gauge charts

Gauge charts

Example: Displays current status in the context of a goal.

KPIs

KPIs

Example: Displays progress toward a measurable goal.

Line charts

Line charts

Example: emphasize the overall shape of an entire series of values, usually over time.

Maps: Basic maps

Basic Maps

Example: are used to associate both categorical and quantitative information with spatial locations.

ArcGIS maps:

ArcGIS maps

 

 

 

 

 

Filled Maps: (Choropleth)

Filled maps

Example: The more intense the color, the larger the value.

Matrix

Matrix

Pie charts

Pie charts

Scatter and Bubble charts

Scatter and Bubble charts

Example: display relationships between 2 (scatter) or 3 (bubble) quantitative measures -- whether or not, in which order, etc.

Slicers

Slicers

Standalone images

Standalone images

Tables

Tables

Example: work well with quantitative comparisons among items where there are many categories.

Tree Maps

Tree Maps

Example: are charts of colored rectangles, with size representing value.  They can be hierarchical, with rectangles nested within the main rectangles.

Waterfall charts

Waterfall charts

Example: Waterfall charts show a running total as values are added or subtracted.

Tell Q&A which visualization to use

When typing natural language queries with Power BI Q&A, you can specify the visualization type in your query.  For example:

"sales by state as a treemap"

Retail Analysis Sample

Custom Visuals in Power BI

Custom visuals are created by developers, using the custom visuals SDK, to enable business users to see their data in a way that fits the business best. Report authors can then import the custom visuals files into their reports and use them as any other Power BI visuals. Custom visuals are 1st class citizens in Power BI and can be filtered, highlighted, edited, shared, etc.

Custom visuals can be in the form of 3 deployment channels:

  • Custom visual files
  • Organization visuals
  • Marketplace visuals

Custom visuals are packages that include code for rendering the data that is served to them.

Import a custom visuals from a file

  • Select the ellipses from the bottom of the Visualizations pane.

Select the ellipse

  • From the dropdown, select Import from file.

select Import from file

From the Open file menu, select the .pbiviz file that you want to import and then select Open. The icon for the custom visual is added to the bottom of your Visualizations pane and is now available for use in your report.

  • Import organization visuals
  • Select the ellipses from the bottom of the Visualizations pane.
  • From the dropdown, select Import from marketplace.

 

Individual Custom Visualizations Types:

Aster plot

Bubbles:

Bubbles

Bubbles1

Bullet chart

Calendar Visualization

Card with States by SQLBI

Chiclet Slicer:

Chiclet Slicer

Industry

Chord

DotPlot

Enhanced Scatterplot

Enlighten Aquarium

Hexbin Scatterplot

Histogram

 

KPI Indicator

Radar chart

Stream Graph

Sunburst

Synoptic Panel

 

Table Heatmap

Tadpole Spark Grid

Tornado

 


Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules