Forum Discussion

liping_qin's avatar
liping_qin
New Member
9 years ago
Solved

average line

  As could be seen from the screenshot, the value of an average line (232, the red line) is not the same as the average value on a table (140.10, on the top right), with the same data set of 448968 ...
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    What you could do is to create the following measure which will then create the line across your dataset

     

    Average Line = 
CALCULATE (
    DIVIDE ( SUM ( '0426'[Update Rate] ), COUNTROWS ( '0426' ) ),
    ALL ( '0426' )
)

    And here is what it looks like once completed

     

     

    And here is the updated file here: https://1drv.ms/u/s!Apxn-69XhcAmhqsVDkaulZTJN9sztA

brjones's avatar
brjones
Advocate I
8 years ago

This problem is not solved!!

 

The reporter said that the average line was displaying the wrong value.  I have the exact same problem with my line charts where I use the built in Average Line feature from PBI.

 

The "solution" posted did not fix the problem of the average line not working - it simply told the OP to just stop using the built in average line.  Yes, there was a workaround posted, but the way the average line works is flawed.

 

If you have a table that calculates an average based on a data set, and the visualization pulls from that same data set and yet somehow comes up with a different average, then the problem still exists.

 

PBI, please fix this.

  • braaten's avatar
    braaten
    New Member
    8 years ago

    I second the request by brjones.  I just discovered this problem and can confirm it is not yet fixed with the latest November 2017 release.  Please add this to your "must fix" list.  Was this working before?  I don't remember noticing this problem.

     

    Thanks.

  • liping_qin's avatar
    liping_qin
    New Member
    8 years ago

    Agree with brjones Hope this could be fix, and have the average line in PBI works without workaround.