Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |