Stacked Column Chart with Extra Functions

[Anonymous]

Hi,

I am looking for a chart like this where green color represents the total order which is 100  for that 1st bar and violet color represents the completed orders which is 50 and also i am looking for the completed % to be appeared in the data label which is 50%.

[Greg_Deckler]

@Anonymous - You can do this with some fancy math using stacked column chart. Basically have to take your top value and subtract your bottom value for your top value.

[lkalawski · Accepted solution]

Hi @Anonymous

You can use stacked column chart with line and you need to adjust the appearance of the chart accordingly. This is the result:

I am attaching a file with this example: https://gofile.io/d/yKo5HE

If you have any further questions, feel free to write. 

_______________
If I helped, please accept the solution and give kudos! 😀 

[amitchandak]

@Anonymous , I think you are looking for an overlapping bar.

Bullet visuals can do that. I doubt bar has that option

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380755?tab=Overview

In the clustered bar, you can have side by sidebar