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.

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.