Forum Discussion

simoncotterill's avatar
simoncotterill
Regular Visitor
3 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 (see below)

How do I show a weekly average instead of the daily values as I think the value variation would reduce and would be easier to look at.

 

Thanks

Need Help
  • Arul's avatar
    Arul
    3 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,

2 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    3 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,

  • Vinit0910's avatar
    Vinit0910
    Frequent Visitor
    1 year ago

    What is ('Calender'[Week_Year]) in the ALLSELECTED measure? If it is a function of Allselected, then it does not apply in Power BI.