Forum Discussion
Min/Max column Chart
Hi Rob83
You can use the stock chart as you said and get thisCreate 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!
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!
Oh SabineOussi great it works :manlol:. Why didn't I think of that, it's so simpel. Thanks a lot
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 ?
Yes it is, you can find it here
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380823?tab=Overview
Perfect! Thank you
