Min/Max column Chart

[Rob83]

Hi all,

I'm wondering if it’s possible to make a min/max column chart?

I have an order lead time for every production order. To make it visible I have made a max order lead time were it show every month the max order lead time from a year of choice. But I also would like to add a min order lead time in the column chart as well so they see the gap between those two. I've tried a Stock chart but that didn’t work because it needed an open and close rate as well. I only need a min and max value but the visualization looks quite the same as a stock chart.

Does anybody as an solution to create this?

Regards Rob

[Elisa_E]

This is a great option to show min/max, but are dates requires always on the x-axis? Could you use another type of text variable?

[SabineOussi · Accepted solution]

Hi @Rob83

You can use the stock chart as you said and get this

Create a new column MIN equal to MIN order lead time, do the same for MAX.

These will serve as the open and close values since the stock chart displays nothing if not all of its fileds are filled.

So eventually the open and low numbers, the max and high numbers overlap so the grey bar is hidden under the green bar.

And make sure the order lead time is formatted as a date.

From the formatting tab of the visual, you can turn off the trend lines so the yellow line doesn't show.

Tell me how it works!

[axy5093]

Hi @SabineOussi

I have a requirement to use stock chart in power Bi, but for some reason don't seem to find a chart of this kind in the built in visuals. Is this a custom chart ?

[SabineOussi]

Yes it is, you can find it here

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380823?tab=Overview

[axy5093]

Perfect! Thank you 

[Rob83]

Oh SabineOussi great it works . Why didn't I think of that, it's so simpel. Thanks a lot

[v-ljerr-msft]

Hi @Rob83,

Could you be more precisely with your requirement by posting your table structures with some sample data and your expected result? It's better to post your expected result with some drawing in this case.

Regards

[Rob83]

Hi v-ljierr-msft,

This is what I'm looking for. A sample not real numbers offcourse. I already have the min en max calculation of the order lead time en put that in an area chart. But people used to get a min max chart and doesn't like this one. But there is no min/max column chart (bar charts) availible. So is there an option to have that availible or is there a solution how I can make this beter visible? Woundering how others handle this.

Regards

[v-ljerr-msft]

Hi @Rob83,

After a few trying, I'm still not able to figure out a solution with the current built-in/custom visuals in Power BI to achieve your requirements. So I would suggest you to submit it on Power BI Ideas to improve Power BI on this feature.

Regards