Min/Average/ Max column Chart: an "unstacked" stacked chart?

[PaulDBrown]

Hello,

I'm trying to create a "stacked" chart where each value is displayed individually, but don't aggregate. In other words, if I'm trying to display a minimum, average and max value, each is displayed against the corresponding axis  and as part of the maximum value: ie they don't all add up to a total. The visual would look something like this:

It is similar to the Stock Chart visual (but I need a category on the x-axis and not a date). I tried both the custom visuals "Candlestick" and "Box and Whisker" but can't get them to display what I need.

Any ideas?

(EDITED: Apart from creating new measures which are the difference between them to stack them up that way, which wouldn't allow to display the absolute value for each)

Thanks!

Paul

[v-sihou-msft · Accepted solution]

@PaulDBrown

In this scenario, you just need to create a calculated table to summarize the min, max and average into columns.

Table =
SUMMARIZE (
    Category,
    Category[Category],
    "Min", MIN ( Category[Value] ),
    "Average", AVERAGE ( Category[Value] ),
    "Max", MAX ( Category[Value] )
)

Regards,

[Anonymous]

Hello, 

I just tried the solution, but it still aggregated the at the axis level and it is not different from the normal stacked chart. I have provided the visual below.

I created the column using the code provided, but the visual I can also achieve by repeating the same filed and selecting it as minimum, average, and maximum respectively. 

Thanks for your efforts.

[PaulDBrown]

@v-sihou-msft

Thank you Simon!! That's exactly what I needed!