01-17-2019 10:34 PM
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.
01-20-2019 06:10 PM
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.
01-21-2019 01:17 AM
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,