I need to show min/max points with data labels on a graph showing call volumes. My solution works until I modify the date range. I created some cards to display the calculated values, and those values are adjusting as expected, but the graphs are not. Note that I have two graphs, one for weekends and another for weekdays. And my base measure is average calls per hour per day.
Weekend graph showing min/max data points with labels
Here are the measures for Max Weekend point
1. Avg Hourly Calls = AVERAGE('Avg Incoming Calls per Hour/Day'[Avg Calls])
2. Avg Hourly Calls - max point on weekends =MAXX( FILTER( ALLSELECTED(DateDim), DateDim[WeekEndYN] = "Y"), [Avg Hourly Calls])
3. Avg Hourly Calls - date of weekend max point = CALCULATE(VALUES(DateDim[Date]),FILTER(ALL(DateDim[Date]),[Avg Hourly Calls]=[Avg Hourly Calls - max point on weekends]))
4. Avg Hourly Calls - weekend maximum = CALCULATE([Avg Hourly Calls], FILTER('DateDim', DateDim[Date]=[Avg Hourly Calls - date of weekend max point]),DateDim[WeekEndYN]="Y")
I have fiddled with using ALL versus ALLSELECTED but am not getting either to work as desired. Your help is appreciated!
------------------------------
Sherry Sparks
------------------------------