Forum Discussion
Average for each small multiple
It seems that you're using the average from "Add further analyses to your visual" which unforunately returns the average for all. If you want the average for each small multiple by month, create a measure
Monthly Average = AVERAGEX ( ALLSELECTED ( 'Date'[Month] ), [Row Count] ) Monthly Average Label = VAR _maxMonth = MAXX ( ALLSELECTED ( 'Date'[Month] ), [Month] ) RETURN IF ( SELECTEDVALUE ( 'Date'[Month] ) = _maxMonth, [Monthly Average] )You'll need to use a custom data label to be able to show the label only for a specific data point.
Please see the attached pbix
It seems that you're using the average from "Add further analyses to your visual" which unforunately returns the average for all. If you want the average for each small multiple by month, create a measure
Monthly Average =
AVERAGEX ( ALLSELECTED ( 'Date'[Month] ), [Row Count] )
Monthly Average Label =
VAR _maxMonth =
MAXX ( ALLSELECTED ( 'Date'[Month] ), [Month] )
RETURN
IF ( SELECTEDVALUE ( 'Date'[Month] ) = _maxMonth, [Monthly Average] )
You'll need to use a custom data label to be able to show the label only for a specific data point.
Please see the attached pbix
This solutions worked like a magic. THANK YOU!!! However, I am not able to position the average to the right of the bar. I labels at every change of month as shown below. I have tried going through your visual option by option and yet failed to contain the labels on the average bar. Can you help with this too?