min median max values and stacked chart

[flawlesscombo]

Hi everyone, 

Trying to create a line and stacked column chart with min, med and max values of survey result by category for various partners. As you can see the y axis is being additive rather than the value for each category being the max i.e 9  Is there a measure to create a range that the functions can adhere to? 

G

Scoring by category and left the partner category out of screenshot.

[v-binbinyu-msft]

Hi @flawlesscombo ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.