Chart - Share in % with Total Quantity

[uie07923]

Hello Colleagues!

I'm trying to come up with the followin chart - this one was built in Excel: 

It is a column chart that shows the Quantity and its % share.

Above it, there is a transparent line with the Total Quantity.

How can I replicate this in PBI?

[v-jingzhang]

Hi @uie07923 

Have you tried the Line and stacked column chart? For the Total Quantity line, you can create a measure to calculate the total value and put this measure into the chart as a Line value to display it. 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[uie07923]

Hello @v-jingzhang and @amitchandak !

This one almost works!

The issue is that the columns must change in size according to the total quantity, and not stack to 100%

Note that it changes according to the value of the "line":

I was wondering if there is any Custom Visual for this.

[v-jingzhang]

Hi @uie07923 

I don't find a custom visual that can meet this need. If you use a stacked column chart, you can toggle on Total labels option in Format Pane to see the total value on each column. But this chart cannot show the % share at the same time. 

Regards,
Jing

[amitchandak]

@uie07923 , As far as I know, power bi shows the only labels for values used, not an additional one, so you can have one of those based on what measure you have used.