Horizontal Stacked Bar Chart Totals Labels - Different column value total as label

[Seantb]

Hi all, 

I'm hoping you might be able to assist with a problem I have with totals data labels for a horizontal stacked bar chart. I have horizontal stacked bar chart showing the top 10 vendors for a company by their invoice count, with the legend splitting the bars for each vendor by whether the invoice was paid on time or paid late. I would like to add a totals label at the end of each bar which has the total $ value for the sum of all invoices for each vendor, but I'm unsure how to do this.

The only totals label i can add is for the total invoice count as the invoice count is the column in the values field of the visualisation. Can you please advise if this is possible if so, how i can do this? 

For clarity, the columns involved are - 

Invoice document # (what I'm using for invoice count) 

Invoice Value $  (the $ value for each invoice document)  

Paid on Time? (the legend, Late/On-time)

Vendor Name (the axis value for top 10 vendors) 

Any help is appreciated. 

[grantsamborn]

Hi @Seantb 

I'm wondering if you can come up with sample data.  Preferably in a pbix but Excel would help.

It would save a lot of time.

[Seantb]

Hi @grantsamborn ,
Sure, I've created an example pbix in the following link - StackedBarChartExample 

To clarify further after looking at the pbix, I am wanting to have the sum total value of all invoices (column Invoice Value $) for each vendor as a label at the end of each bar, per below highlighted in green.

[grantsamborn]

Hi @Seantb 

I've taken a look at the pbix and I don't really think there is a feasible option.

Maybe someone else can help.

[Seantb]

Thanks for taking a look @grantsamborn. The closest solution I've come up with is to add the value into the tooltip, but then this requires the user to hover over each vendor individually, not ideal if they're wanting to compare vendor-vendor by invoice count and value. 

Anyone else got any ideas?

[grantsamborn]

Same thing I thought I'd try but with the same success.