Visual chart to show price range

[Elisa_E]

Hello,

I need to show a chart showing price ranges accross multiple companies. For each company I have a minimum and maximum value to show. I was trying to use the trading chart, but it seems I need a date value for the X-axis instead of company.

Any ideas?

Thank you.

[Anonymous]

Hi @Elisa_E,

You can try to use clustered column chart to achieve your requirement.

Sample:

Company to axis field, amount columns to value fields with different summary mode.(max and min value)

Regards,

Xiaoxin Sheng

[Elisa_E]

Thanks for the reply. Ideally what I needed was for column to represent the range (like floating columns), with start point at the minimum and end point at the maximum, accross the different companies (like the image below).

Maybe there is an easy way to format this from using a stacked column, but I haven't been able to see it as of yet.

[Anonymous · Accepted solution]

Hi @Elisa_E,

Current power bi not support to setting start point of chart.
For your requirement, I'd like to suggest to you to take a look at 'gantt' and 'box and wisker chart', they seems suitable for your requirement.

In addition, you can also submit this to ideas forum.

Regards,

XIaoxin Sheng

[Elisa_E]

Many thanks for the suggestions. I will give these a try.

[cys]

Hi,

I am wondering if it is possible to add a dot or somehow highlight the most recent value in the time series on a box and whisker plot? Instead of the mean dot, could I use the latest value instead? Can I change the definition of the mean possible?

Alternatively, are there other charts which would show a price where I could also highlight the current value?

Thanks