Power BI Visualisation Best Practices
It is said that your data is only as good as your ability to communicate it, which is why choosing the right visualisation and presenting it well is so imperative.
Today we’ll look at several common visualisations available in Power BI and their recommended design practices.
* All samples on this blog are created using standard visualisation elements in Power BI Desktop (May 2016 release) *
Visualisations in A Nut Shell
Before creating any visualisation, it is useful to understand the types of data that are visualised and their relationships to each other. Here are some of the most commonly used ones from Power BI :
* Courtesy of Data Visualization 101 published by Hubspot
Bar & Column Charts
Bar charts are very versatile. They are best used to show change over time, compare different categories, or compare parts of a whole
Do’s & Don’ts
Pie & Donut Charts
Pie chart is arguably one of the most popular (and controversial) charts of all time. They are recommended for making part-to-whole comparisons with discrete data. The visualistion works most effectively when there are only a few discrete values.
Do’s & Don’ts
About Order of Pie Slice
Although itis not configurable in the current release of Power BI (not yet), but I generally recommended positioning the largest pie slice at 12 o’clock position, then place remaining slices in descending order, going clockwise direction.
To Be Continued (Part 2)
In the next session I will talk about design practices for the following visualisations:
- Line Chart
- Area Chart
- Scattered Plot
In Part 3, I will also go over the following visualisations:
- Bubble chart and visualisation using map
- General advice for a better visualisation design
Stay tuned !