Bar Chart Reference Line Label

[selcukcadir]

Hi all,

How can we solve the problem in the attached document?

Thanks...

[vinay_hg]

what is the problem. can you pls brief.

[vardhancse]

in chart properties->presentation->Reference line. based on condition the reference line will be shown in bar chart

[selcukcadir]

     Max value : 2  and should be max Month = Oca

[vardhancse]

Try to enable the option

[selcukcadir]

Label enable ok.

I do not calculate the date (max Month) information

[selcukcadir]

[#8 · Accepted solution]

Hi,  Could you try this?

Max(Aggr(sum(value1) / sum(value2),MonthDate )) & ' Max Month : ' & FirstSortedValue(MonthDate, -(value1/value2))

Regards

[MarcoWedel]

='Max Value : ' & Max(Aggr(sum(value1) / sum(value2),MonthDate )) & ' Max Month : ' & FirstSortedValue(MonthDate, -Aggr(sum(value1) / sum(value2),MonthDate ))

hope this helps

regards

Marco

[MarcoWedel]

If

FirstSortedValue(MonthDate, -(value1/value2))

matches your requirements, then there is only one value1/value2 combination per month in your data, which means that you could also abbreviate your other expressions like:

=Max(value1/value2)

for the reference line and

='Max Value : ' & Max(value1/value2) & ' Max Month : ' & FirstSortedValue(MonthDate, -(value1/value2))

for the text in chart.

hope this helps

regards

Marco