Reply
Highlighted
Frequent Visitor
Posts: 2
Registered: ‎01-17-2019

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

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.

 

image.jpg

 

Regards,

Ratish

Community Support Team
Posts: 2,529
Registered: ‎03-15-2018

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

Hi @ratish1307

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

1.png

 

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]))

2.png

 

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.

Frequent Visitor
Posts: 2
Registered: ‎01-17-2019

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

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