dynamic Top limit for line and stacked chart

[baneworth]

Hello Community

I use a Line and stacked column chart to show the results as the line and the 3 targets (green, yellow and red) as kind of shading with graphs.

The lower (green) and mid (yellow) limits come from excel and are fixed. The Toplimit i want to show dynamic, meaning from the highest result + 10.

I created the DAX to show me the MaxResult and then created the measure for the TopLimit.

Dax to get Max of result (findings)

DAX for toplimit (red graph)

If you take a look at the screenshot you can see that now the TopLimit applies to each SerialNr individually which is wrong.

I understand why this happens but have no clue how to fix it.

Obviously the red Graph should be full like the green and yellow ones based on the Max finding.

If anyone could help me out or even suggest something different to achieve the same i would be very thankful.

Best regards

Matthias

[amitchandak · Accepted solution]

@baneworth , Your limit should be like

calculate( Maxx(values(Table[Axis COlumn]), [Max Resolved]), allselected()) +10

[baneworth]

@amitchandak thank you very much!

Appreciate it