October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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
@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
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |