Place data labels outside bars in stacked bar charts

[Anonymous]

Dear Community,

is there a function to place data labels OUTSIDE the bars of a stacked bar visuals? It does not seem to be an availalbe option - and it looks like that if the size of the bar is too small, there is actually no way to display the label itself- which I find very unconvenient (I tried all possible options and combinations in the panel)

Thanks for any tips or trick  🙂 

Luca

[Afives522]

I was able to have a workaround on this.
You need to use the Line and stacked column chart to do this.

1. You'll use the Line y-axis as the total value of your Column y-axis.

Ex. 

- Column y-axis has  Product-A and Product-B

- Line y-axis Product-C (which is the sum of Product-A and Product-B)

2. Go to "Format your visual" > Lines > Stroke width > 0 px

3. Go to "Format your visual" > Markers > Shape > Type > "-" 

4. Go to "Format your visual" > Markers > Shape > Size > 1 px

4. Go to "Format your visual" > Data Labels> Series > {Product-C}

5. Go to "Format your visual" > Data Labels> Position (line) > "Above"

5. Go to "Format your visual" > Data Labels> Values > Custom Label > "On", then drag the Product-C as the Field.

[v-chuncz-msft · Accepted solution]

@Anonymous 

There is already an idea, you may leave a comment and vote it up.