reference line for each bar

[alexpanjhc]

Hi

I am trying to create a reference lines for each category.

My dimensions are categories and years each bar stands for one category. the expression is sum(Amount)

some bars I will to show where the 20%of that bar and some bars I want to show 40%.

How can I achieve it in the bar chart or else?

thanks!

[Ivan_Bozov]

You need to use a combo chart, add a second measure to calculate the percentage based on your dimension, e.g.

IF(Dimension='A', 0.20*SUM(Amount),

IF(Dimension='B', 0.30*SUM(Amount),

IF(Dimension='C', 0.40*SUM(Amount))))

... and finally change the measure presentation to Marker. The setting is under Data > Measures > Your second measure.

[alexpanjhc]

Thanks, but combo chart only have 1 dimension

[Ivan_Bozov]

I would still do this and put the year as filter. Or in your case have three combo charts next to each other for each year. You cannot achieve your requirement with a simple bar chart.