Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Ritaf1983

Graph from the "don't try this at home" drawer or a story about ...

Several years ago, I was asked to add a graph to the sales dashboard. Its purpose was to show to the salesmen the relationship between sales performance and customer profitability.

 

A manager who characterized the graph was very experienced. It seemed he knew exactly what he needed. He even drew the sketch for me, and I thought it was really cool. The result – is 2 graphs as shown below.

Ritaf1983_0-1689730227588.png

What went wrong with these beautiful graphs?

Ritaf1983_2-1689730391587.png

 

 

1. A single place with contradictory messages can be confusing.

 

As an example,

 

A pair of bars of the same length, but in different colors - one green (good), the other orange (bad).

Ritaf1983_1-1689730327287.png

2. There is too much "noise".

The dashboard's purpose is to show issues to improve, so these are the areas that need to be highlighted. In this one, there are colors of traffic lights. Every single one of them demands attention on its own. However, when all three appear together, a decoding operation is required to understand the differences.

 

Another challenge I added was to separate shades in addition to color differences.

Ritaf1983_3-1689730448271.png

3. The most important statistic of profitability that needs to be rated is not shown - users need to encode it by color.

As a result, there is no chance to understand the relationship between profitability and sales, which was the purpose of the graph...

Which alternatives are available?

 

Create a visualization that allows you to:

  • Analyze all indicators together.

  • Put them in the correct order of importance.

  • Using color effectively for emphasis and warnings.

  • Provide all the necessary data without guessing.

Ritaf1983_4-1689730575715.png

Let me know what you think by giving us a thumbs up,

Greetings, Rita 🙂