Better Visualization to Show Insights

[v-jeevanay]

Hi Friends,

I am using the following data to visualize the data in Power BI.

Region	Current Sales	Min Sales	Max Sales
US	2,102	2,454	2,851
ANZ	2,496	2,914	3,385
Asia	4,669	5,450	6,333
Europe	1,198	1,398	1,625
UK	2,276	2,657	3,087

I have created following two visuals.

Option #1:

Option #2:

However, my client is not happy with the above two options, they are asking for a better presentation of the visual.

Can you please suggest me a best possible visulization trick or method or visual to showcase the insghts best possible way.

@amitchandak @Ritaf1983 @Greg_Deckler @ChandeepChhabra @GilbertQ @dbeavon3 

[Anonymous]

Hi @v-jeevanay 

Here I have another idea in mind, and I would like to share it for reference.

I create a Clustered bar chart:

In the Format pane, select Bars. In the Layout box, adjust the Overlap and set the Space between series to 100%. Note that the Sort by value button should be opened to avoid obscuring data.

Open the data labels, the result is as follow:

By the way, you can adjust the thickness of the bar by changing the value of Space between categories.

Hope it helps,

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-jeevanay]

Hi @Anonymous 

Thanks for your time.

Client is not ok with the above solution. I am exploring more altrernative options.

[Anonymous]

Hi @v-jeevanay 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-jeevanay]

Hi @v-zhengdxu-msft 

There is not correct solution for this problem. Hence not marking any solutions.

[Ritaf1983]

Hi @v-jeevanay

I understand the client’s difficulty with the charts in the image.

A clustered bar chart seems simple and basic, but in reality, it’s almost impossible to grasp the comparison between the countries. Our brain can only perceive the comparison within each cluster separately. When you add lines above the bars, it further challenges the reader, as there are even more elements to interpret.

Regarding the alternative: To choose the right chart for the client, we need to understand their goal—what questions they are asking and what they will do with the data tomorrow morning.

If we are talking about comparing ranges (distance between minimum and maximum, maximum and current sales, etc.), then the dumbbell chart shown in the image could be suitable.

On the other hand, if the focus is on ranking sales by country, then a table combined with a graph might help, with a separate chart for each category.

If a specific category needs to be highlighted, it can be distinguished by color.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[v-jeevanay]

Hi @Ritaf1983 ,

Thanks for your time.

Client is not ok with the above solution. I am exploring more altrernative options.