Forum Discussion

Elisa_E's avatar
Elisa_E
Icon for Helper I rankHelper I
8 years ago
Solved

Visual chart to show price range

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 n...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
Elisa_E
Icon for Helper I rankHelper I
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      Elisa_E
      Icon for Helper I rankHelper I
      8 years ago

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

      • cys's avatar
        cys
        New Member
        7 years ago

        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