Power BI Custom Visuals Series: Table Heatmap

In this series, we take a look at some of the Power BI custom visuals available on the Office store, and shed a light on what the visualisation is, how the Table Heatmap works and the impact it can have in a Microsoft Power BI report.

For the most part, data visualisation delivery is less of a science, and more of an art. If given a set of data, it is up to the artist to determine in what way that data will be presented, such that its appeal to the reader is so strong that it can influence decision making within an organization.

For that reason, Power BI has an expanded list of custom visuals to help data artists craft the masterpiece. It turns complex and unengaging data into an impactful and effective source of information that decision-makers can rely on.

Power BI Custom Visual – Table Heatmap

Good Data Strategy dictates that an effective endpoint for data analysis is the point at which insights can be actioned as part of an informed decision.  What ignites those insights are strong visualisations that tell clear narratives. One such visualisation is the Table Heatmap:

Table data can be easy to understand, but difficult to read. Rows of numbers appear the same, differences between figures are not obvious, and the overall message that the table intends to tell has become altogether unclear. By adding a colour-schemed heat map, however, users can see behind the numbers and quickly identify differing levels of relative performance without having to perform mental gymnastics. This ability to visually discriminate numbers is increasingly becoming crucial in making prompt and effective business decisions.

The Table Heatmap takes a simple table and turns it into a visually compelling and dynamic source of information for decision making. Combining the intuitive format of a table with the instinctive nature of a colour gradient, this visualisation makes for a far more effective representation of information without overwhelming or misinforming users.

Use Cases

Typical use cases include:

  • Sales figures per product, across time
  • Incident counts per incident type, across employees
  • Revenue growth per month, across financial years
  • Budget variances per account, across months

Additional Functionality

As a bonus, the colour scheme can be customized to match corporate colours, adding unique and impactful personalization to the visual.

Summary

By adding a heat map to a table, users can expect to instantly identify areas of interest or concern, empowering them to make informed decisions about their business. By harnessing the power of colour gradient perception, the Table Heatmap will prove useful in analysing operations, determining where resources need to be allocated and understanding performance patterns.’

 

Matthew Oen

Matthew Oen

Matthew is a consultant at FTS Data & AI. He specialises in Power BI architecture.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.