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
robdwright65's avatar
robdwright65
New Member
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