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,
Could you be more precisely with your requirement by posting your table structures with some sample data and your expected result?:smileyhappy: It's better to post your expected result with some drawing in this case.
Regards
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
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.:smileyhappy:
Regards