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 need a date value for the X-axis instead of company.

Any ideas?

 

Thank you.

  • 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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

      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

        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