Forum Discussion

MuthalibAbdul's avatar
MuthalibAbdul
Helper II
1 year ago
Solved

Average for each small multiple

  I am trying to have individual monthly average for each location. x axis is Calender[Month] Y axis is FinalTable[Patient Name] Small multiples is FinalTable[Location] I cannot use sum si...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi MuthalibAbdul 

    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

     

lbendlin's avatar
lbendlin
Super User
1 year ago

This may be possible with a Deneb visual.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523