Forum Discussion

G0ggs's avatar
G0ggs
Icon for Helper I rankHelper I
5 years ago

PowerBI bar chart with error bands

Hello,

 

Is there a way to create a bar chart with error bands? 

 

The example I have is a number of cars which I have said should have a certain speed (low, medium and high)

 

I then measure the speed of the car and get 1 speed. As I have multiple tests I would like to make a bar chart which shows also on it the low-medium-high prediction as an error band so I see where the bar chart lies. This is a quite way to visualise the outliers. 

 

Also if anyone has any other views they might suggest that are useful Im all ears 🙂 

Thanks,

G

5 Replies

  • G0ggs Can you share sample data and sample output?

     

    I am thinking of a bar visual with two columns on axis bands, speed and we should color for speed using conditional formatting

     

    Visual show at this time on video

    https://youtu.be/2P5BBRN853c?t=528

     

     

    • G0ggs's avatar
      G0ggs
      Icon for Helper I rankHelper I

      Hello thanks for your reply here is the data:

       

      Car IDCar test speedMin acceptable speedExpected  speedMax speed
      1702040100
      260305090
      350105070
      460206080
      555456080
      640507080
      710154060
      860405055
      9708090100
      1050455065
      • v-janeyg-msft's avatar
        v-janeyg-msft
        Icon for Community Support rankCommunity Support

        Hi, G0ggs 

         

        What kind of result do you want?

         

        Best Regards

        Janey Guo