Forum Discussion

Ruz's avatar
Ruz
Regular Visitor
2 years ago
Solved

Creating an Average Line within a line chart

Hi   I have a Line Chart with setup suc that Month as the x-axis, year as the legend, and my values with many data points averaging on the y-axis as below.  I want to add a line to this chart where...
General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Ruz ,
    To add a line to the chart to show the average value by month, you can create a new metric to calculate the average of each monthly value.

    Avg =
AVERAGEX ( GROUPBY ( 'Table', 'Table'[Month] ), AVERAGE ( 'Table'[Values] ) )

    Final output:

     

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

    If it does not help, please provide more details with your desired out put and pbix file without privacy information.

     

    Best Regards,

    Ada Wang

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Ruz ,
To add a line to the chart to show the average value by month, you can create a new metric to calculate the average of each monthly value.

Avg =
AVERAGEX ( GROUPBY ( 'Table', 'Table'[Month] ), AVERAGE ( 'Table'[Values] ) )

Final output:

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

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