Forum Discussion

robdwright65's avatar
robdwright65
New Member
3 months ago
Solved

Bar and Line Chart With Date – Fixing Average Line Not Respecting Date Filters in Stacked Co

Hi, I hope someone can help.   I was trying to add an average line to a stacked column chart in Power BI. Initially, the measure either produced a non-flat line or didn’t match the expected averag...
Need Help
Show and Tell
  • robdwright65's avatar
    robdwright65
    3 months ago

    I've just found the issue.

     

    I was using the code above (with the flat average line).

     

    However, I found I was using two different dates, in the code 

    DIM_Calendar[Date]
    In the chart I was using, 
    FACT_BadgeRecordsSlim[Date] - I've now changed this and it has removed the months that are filtered out.
     
    Hope this helps someone else.
     
    Thanks
    Rob
ERD's avatar
ERD
Community Champion
3 months ago

Hi robdwright65,

 

Did you try to add a Reference line? You need to choose an Average line type and a measure in Series (the average of this measure will be taken).

 

  • robdwright65's avatar
    robdwright65
    New Member
    3 months ago

    Hi ERD , thanks for looking at this.

     

    Yes, I tried the standard route of adding an average line, but the value is incorrect as there are other calculations that need happen to provide the true average. We are removing weekend and low count days.

     

    Thank Rob