TOPN

[Anonymous]

Hi All,

I'm very new to PowerBI, so not sure if this is even the location I need to post to.  I'm having difficulty working with topN.  I have to use topN for one of my charts but need it to associate with all slicers and drilldowns chosen on the dashboard.  Can someone provide any ideas on how to get this to work. 

Example, I have 5 charts and 4 slicers on my dashboard.  One chart is supposed to be a treemap showing the top 5 ID's contributing to whatever is drilled down from one of the other 3 graphs AND whatever slicer value chosen.  Is there a way to do this?  OR if this was already answered, can someone point me to it?

Thanks!

TP

[amitchandak]

@Anonymous , You can use a visual level TOPN filter or create a TOPN measure

example

calculate([Net Sales PY], TOPN(2, allselected('Address'[Country ISO]), [Net Sales PY],desc), values('Address'[Country ISO]))

refer: TOPN: https://youtu.be/QIVEFp-QiOk 

Others

Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

Power BI- Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE