it is possible to display contribution % on top of the bar or below of the bar ?

[Paulyeo11]

Hi All

[v-janeyg-msft]

Hi, @Paulyeo11 

It’s my pleasure to answer for you.

According to your description,Do you want to display percentages in a stacked column cahrt?Have you tried the method @themistoklis  shared? Is this the result you want?

Like this:

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Paulyeo11 , Enable show label and change measure to % of the total.

[Anonymous]

Hey @Paulyeo11 

Their are 2 ways:-

1. Drag sales in values field and inside the field, click on the dropdown and select show value as > percentage of Grand Total.

2. Make a measure = divide(sum(sales),calculate(sum(sales),allselected(segment)),0) = drop this measure in value field and convert it into percentage.

Thanks,

Please mark it as solved if you are fine with the solution.

[Paulyeo11]

Hi All

Thank you very much for all your sharing. 

I still cannot figure out how to do it. Encloed my PBI file , hope some one can share with me how to make it.

https://www.dropbox.com/s/p8taizvflqhb7tb/PB_TDS_V080%20display%20sales%20contribution%20on%20bar.pb...

Paul

[themistoklis · Accepted solution]

@Paulyeo11 

1. Click on the graph visual

2. Go to Visualisations Pane

See image below,

Then go to 'Format' tab and for orientation select Top

And for Position: Outside End

[themistoklis]

Hello @Paulyeo11 ,

When you add the metric, change it to show value as 'Percent of Grand Total'.

See link and image below:

https://www.youtube.com/watch?v=qeWN5gq9EE8