Forum Discussion

Seantb's avatar
Seantb
Frequent Visitor
3 years ago

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

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. 

5 Replies

  • 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's avatar
      Seantb
      Frequent Visitor

      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's avatar
        grantsamborn
        Icon for Solution Sage rankSolution Sage

        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.