Power BI

Have you tried


for Microsoft Power BI

This blog is part of the Bullet Chart Blog Series.

In this blog, we will be looking at some of the common use cases of the Bullet Chart using xViz Custom Visuals for Power BI.

Use Cases – Summary

  1. Highlighting performance against benchmark using Conditional Formatting
  2. Comparing performance against 2 values (Comparative band + Benchmark)
  3. Comparing performance against 3 values (Comparative band + 2 Benchmark values)
  4. Qualitative analysis (Good, Average and Bad)
  5. Vertically oriented Bullet Chart for Trend Analysis

Use Cases – Description

1. Highlighting performance against benchmark using Conditional Formatting

5-use-cases-bullet-chart-custom-visuals-microsoft-power-bi

Actual vs Target Value

 

Example: A Retail Company, trying to view their Sales for this quarter. With the help of a Bullet Chart, one can easily visualize sales progress by comparing the Actual Sales vs Target. Note that the red color quickly highlights the fact that the Target for this quarter has been missed.

5-use-cases-bullet-chart-custom-visuals-microsoft-power-bi

 

2. Comparing performance against 2 values (Comparative band + Benchmark)

5-use-cases-bullet-chart-custom-visuals-microsoft-power-bi

Actual vs Target and Previous Period

 

Example: A Bullet Chart could be used for Revenue Analysis where the Actual revenue could be compared with the Target and previous period Revenue. This also helps in looking at the target value relative to last year which makes it more powerful.

3. Comparing performance against 3 values (Comparative band + 2 Benchmark values)

5-use-cases-bullet-chart-custom-visuals-microsoft-power-bi

Actual vs Same Period Last Year (SPLY), Plan and Forecast

 

Example: A Manufacturing Company trying to analyze the order quantity of the product by comparing Actual quantity to the same period last year, Target and Forecasted value. This would help in Demand Planning forecast numbers leading to better Sales Planning.

 

4. Qualitative analysis (Good, Average and Bad)5-use-cases-bullet-chart-custom-visuals-microsoft-power-bi

 

The qualitative scale not only helps to visualize the target achievement: poor, satisfactory and good but also the degree to which it resides within that state. You could learn about the different ways to configure the Comparison Bands here.

Example: Using the qualitative range one could easily spot the gross margin lying in the good range. Another example could be when percentages are involved with the target being 100%.

5. Vertically oriented Bullet Chart for Trend Analysis

5-use-cases-bullet-chart-custom-visuals-microsoft-power-bi

Orientation

 

In certain cases, the vertical orientation of the Bullet Chart seems more beneficial than horizontal based on the real estate available. For example, you could visualize the trend information much easier in vertical orientation than horizontal.

To get the latest version of the custom visual, reach out to us here. This blog has been originally published on xViz website. Click here to visit and know more about custom visuals for Microsoft Power BI.

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com