Forum Discussion

simoncotterill's avatar
simoncotterill
Regular Visitor
4 years ago
Solved

How do I show average weekly on my graph?

Hi, I'm new to BI so forgive me if this request is basic. I track the availabilty of 5 different equipment types daily and show these currently on a graph. The issue is the graph looks very messy (s...
Need Help
  • Arul's avatar
    Arul
    4 years ago

    simoncotterill ,

    Create week column from date column and use it in X-axis the use the formula like this,

    Week average = 
CALCULATE(AVERAGE(your column)/7,ALLSELECTED('Calendar'[Week_Year])

    Thanks,

Arul's avatar
Arul
Icon for Super User rankSuper User
4 years ago

simoncotterill ,

Create week column from date column and use it in X-axis the use the formula like this,

Week average = 
CALCULATE(AVERAGE(your column)/7,ALLSELECTED('Calendar'[Week_Year])

Thanks,