Setting targets helps us measure progress and stay motivated towards a goal, whether it’s personal or business-related. Positive results motivate us while falling behind highlights areas for improvement. Figuring out the best way to visualize a target, for example, in Power BI, can be challenging, as it heavily depends on which actions the audience you are designing for wants to take with the results.
This article will show you different ways to display if a target is hit or missed visually. All visualizations are standard in Power BI, mostly tweaked with conditional formatting. If you are interested in AppStore visuals, I mention some at the end of the article.
Before you start creating the visual, it’s important to understand what you want to visualize and why. Also, don’t forget about defining (together with your audience) the actions resulting from answering whether or not a target was hit. Why? Because this will help you choose the best visualization for your audience! It seems simple, but for example, a statement like “We want to see if we hit or miss our sales quota” can be visualized in several ways. Some of the questions you can ask are:
Visualizing daily targets can be tricky. Quickly comparing specific days in bar and line charts can become difficult due to the amount of data.
Unfortunately, the custom visuals provided by Power BI don’t offer a calendar that makes it easy to visualize daily results. However, a workaround can be to use a matrix visual in combination with conditional formatting.
In the example provided, you see a daily overview for January till March with colored columns when a target was either missed or hit. Using just 1 bold color makes it easier to interpret the information. If you would color this visual red and green, the visual gets busy and harder to interpret.
Using a matrix visual with conditional formatting in Power BI can help identify patterns and track missed or met targets in a visually appealing and easy-to-interpret way.
When visualizing a target monthly, you should check if the target is flexible or fixed throughout the year. For example, some companies have a specific percentage or amount they want to reach every month, regardless of the month. At the end of the year, they want to see an overview of all the months and the targets hit or missed.
In this example, I’ve chosen two different approaches.
Next to the line and column chart and the matrix visual a line chart also can be an option to visualize a hit or missed target. Line charts are a great way to compare values with each other and they do not take up a lot of space. However, you should remember that the values are a little more challenging to compare than, for example, in a bar chart (try it yourself by comparing this visual with the one above).
In this example, I chose to show the target as a dashed line and the line chart with the results witha solid line. Additionally, I used conditional formatting on the data labels. Also, the values shown are the distance to the target.
While this visual shows, in essence, the same information as the visuals above, it is used to interpret the data differently, focusing much more on the numbers behind the question “Is the target hit or not.”
With a flexible monthly target, you could also choose a line and clustered column chart. However, visuals can feel crowded very quickly when too much information is provided, for example, when you add (too many) data labels. In the example, I show a chart with and without data labels for the target amount, not the result. If data labels for the results also would be added, this would lead to quite a busy visual. Therefore it is essential to know which level of detail (and which questions they try to answer) is required to work for your audience.
Another option to visualize a flexible target is a line chart. A line takes less space in a visual, leaving more room for data labels without making it look cluttered. But also here, knowing which labels are interesting for your audience is essential. Do they know the target, or is it mentioned in the title somewhere else in the dashboard? Are they interested in the amount, or are they more interested in the distance to the goal?
Next to a line chart, an area chart also can be a great visual since the shade (showing the distance to the goal) can be a visual hint.
There are many visuals in the AppStore to visualize a target; for the purpose of this article, I have selected two that I find useful. Remember that most AppStore visuals require (paid) licenses. The great advantage of these visuals is that they offer the opportunity to visualize data in ways that are impossible with the standard visuals in Power BI.
Feel free to contact me!