how to add the percentage line(trend line) to bar chart?

[Anonymous]

Hi Gurus,

Need your help. Could you please let me know how to add a percentage line to my bar chart? I am newbie to Power BI. thanks for your support. Attaching the screen shot of the image which I would like to replicate.

Thanks for your time and help.

Regards,

Ratish

[v-juanli-msft]

Hi @Anonymous

if you use clustered column chart, you could add a trend line as below, then add a shape "arrow" on the line.

Based on test, stacked column chart doesn't support add a trend line like this.

If you have to use stacked bar chart, here is a workaround.

use Line and Stacked column chart instead, assume you have such dataset, 

create a measure, add this measure to the "Line Values"

Measure = CALCULATE(SUM(Sheet1[value]),ALLEXCEPT(Sheet1,Sheet1[month]))

Best Regards
Maggie

“
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
“

[Anonymous]

Hi Maggie,

Thanks for your reply and help, it surely helped, I also want the percentage to be displayed. Like every month a percent value on top of the line should be seen.

For this I might have to create a new measure is it?

Thanks & Regards,
Ratish