Forum Discussion
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...
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,
What is ('Calender'[Week_Year]) in the ALLSELECTED measure? If it is a function of Allselected, then it does not apply in Power BI.