Power Bi has a wide range of different types of visualisation to help those viewing the published report to understand the data they are portraying effectively.  Many of these are charts or graphs which are great at displaying relative sizes of data, trends over time, proportions of the whole and much more.  The package also has monthly updates so this list is regularly growing so keep an eye out for new additions to those mentioned here.  Find out which is the best chart type in Power BI in different situations.

 

Bar Charts (bars are horizontal)

Stacked Bar chart: The data bars are stacked on top of each other.  This is useful if you want to see an overall result for the data but then need to split it down into its component parts.

Clustered Bar Chart:  The bars are viewed side by side rather than stacked which makes it easier to see the relative sizes of each part.

100% Stacked Bar Chart: Similar to the stacked bar chart but each bar has the same overall height (100%) so the proportions of each bar can be compared more easily rather than the specific figures.

Column Charts (bars are vertical)

The same options are available as for a bar chart but the data is arranged vertically instead of horizontally.

Line and area Charts

Line Chart: Used to show trends over time where the data on the x axis is normally a date of some type.  A line is used to join the data points

Area Chart:  Same as a line chart but the area below the line is shaded.

Stacked Area Chart:  The data figures are stacked on top of each other like with stacked bar and column charts.

Combination charts

Both these chart types are most beneficial where the size of the data is vastly different or representing very different data.

Line and stacked column: Combines a line and stacked column chart

Line and Clustered column: Combines a line and clustered column chart

Ribbon chart

Similar to a stacked column chart but with the horizontal axis being a date and the corresponding points for each set of data being joined together

Waterfall chart

Often used in understanding or explaining the gradual transition in the quantitative value of an entity which is subjected to increment or decrement. Often, a waterfall or cascade chart is used to show changes in revenue or profit between two time periods.

Funnel chart

Like a bar chart but the data bars are centralised. It is often used to represent stages in a sales process and show the amount of potential revenue for each stage.

Scatter chart

Used to show 2 sets of values for data and discover if there is a dependency of one on the other or not.

Pie charts, Donut charts and Treemaps

Pie chart:  Shows the proportion of the whole with the angle of the pie representing the size of each set of data.

Donut Chart: Similar to a pie chart but multiple rings can be used to show multiple sets of data on the same chart.

Treemap: Similar to a pie chart but the size of the rectangle represents the size of the data.

It is not surprising that Charts are used a huge amount in Power BI as they help you to get a feel for the data at a glance if the right option is chosen.  It is easy to change from one chart type to another if the wrong option is initially chosen but the fields may need to be rearranged to represent the data correctly.

 

Want to learn more about Power BI? Then email lara@laramellortraining.co.uk to discuss how I can help or have a look at the Power BI Courses I run. 

MEMBERSHIPS

FOLLOW LARA