Forum Discussion

tomi5's avatar
tomi5
Helper II
2 years ago
Solved

How to plot average line and upper/lower bounds on visual?

Hi, I have the following sample data and chart. My actual chart is in power bi but this is just for demonstration.     I have put a line chart in power bi and added the maintenance costs as ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi tomi5 

     

    Thanks for the reply from Greg_Deckler .

     

    If you can consider using Line and stacked column chart visualization, please refer to the following test:

     

    Measure:

     

    Measure = CALCULATE(AVERAGE('Table'[Maintenance Costs($)]), ALLEXCEPT('Table', 'Table'[Car Age(Years)]))

     

     

    Output:

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

tomi5 Have you looked at using the Analytics pane?

  • tomi5's avatar
    tomi5
    Helper II
    2 years ago

    Analytics pane plots a flat average line over the entire dataset rather than calculating the average for each year and then plotting a line based upon that. The latter is what I need so the analytics pane is not suitable.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi tomi5 

       

      Thanks for the reply from Greg_Deckler .

       

      If you can consider using Line and stacked column chart visualization, please refer to the following test:

       

      Measure:

       

      Measure = CALCULATE(AVERAGE('Table'[Maintenance Costs($)]), ALLEXCEPT('Table', 'Table'[Car Age(Years)]))

       

       

      Output:

       

      Best Regards,
      Yulia Xu

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.