The Best Power BI Visuals

The Visual Vocabulary is a complete guide to which Power BI visuals to use. Depending on the data you want to display, you will need to use one or another. 

Gif Comparativa Gartner Bismart BI

If you have a dashboard created by Bismart you will see that the graphics, visuals and custom visuals we have put together do not respond to the consultant's personal preference, but to a worldwide consensus on which Power BI visuals are used in each case. 

Bismart recommends the use of this graphic symbolism to visualize concrete data and represent the information in a simpler way. This is known by different names: dataviz, data visualization, visual vocabulary, data stories, Power BI visuals, better chart choices...

Basically, you should know that there is a visual vocabulary supported by the Financial Times Graphics Team and by Microsoft Power BI and Tableau to facilitate the choice of graphs to represent data. The Visual vocabulary does not seek to prescribe how graphs should be made, but to take advantage of opportunities to use them in conjunction with words.

The creation of this visual vocabulary is due to the fact that, as the Financial Times explained, an important part of society is not able to understand simple graphics. This is a serious problem, because in the post-truth era it is crucial to know how to move between data and information in order to form critical opinions. Moreover, it is not possible to avoid them and explain the data they contain, because the information transmitted with certain graphics cannot always be replaced by verbal explanations.

Another problem related to the graphical representation of data is that the companies that make dashboards are experts in data processing, but they are not trained to share complex information to non-expert audiences.

That is why at Bismart we train our professional statisticians and why they always work together with expert consultants in the transmission of complex information.

One of the actions that comes out of this relationship is the use of this visual vocabulary that helps to encourage a better choice of graphics and, ultimately, bring data experts closer to people with basic statistical knowledge.

 

Inspired by the work of the Financial Times, SQLJason created the Power BI version of Visual Vocabulary. He added some more graphics that seemed relevant to him: 

The Choice of Graphs

The choice of graphs depends on the category and type of data that will be shown. They are divided in the following categories:

Deviation

Emphasizes variations (+/-) from a fixed reference point. Normally, the benchmark is zero, but it can also be a long-term objective or average. It can also be used to show sentiment (positive/neutral/negative).

Correlation

Displays the relationship between two or more variables. Keep in mind that, unless told otherwise, many readers will assume that the relationships shown to them are causal (i.e., one cause the other).

Ranking

Used when the position of an element in an ordered list is more important than its absolute or relative value.

Distribution

Displays the values in a dataset and how often they occur.

Change over time

It emphasizes changing trends, which can be short movements (days) or extended series spanning decades or centuries. The choice of the correct time period is important to provide a suitable context for the reader.

Part-to-whole

They show how a single entity can be broken down into its constituent elements.

Magnitude

They show size comparisons. These can be relative or absolute. They usually show a "counted" number (e.g., barrels, dollars, or people) rather than a calculated rate or percent.

Spatial

It is used only when precise locations or geographic patterns of the data are more important to the reader than anything else.

Flow

Shows the reader the volumes or intensity of movement between two or more states or conditions. These can be logical sequences or geographic locations.

Here you can download the Financial Times Graphics Team PDF explaining this new Visual vocabulary and how to use it:

DOWNLOADIf you prefer, you can download the Power BI PBX file with all graphics and visuals. Download it and you will be able to copy the resources and use them in your own Power BI Report.

DOWNLOAD PBX

LEAVE A COMMENT