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