Dear Members,
I’m writing for the first time and I’m very new to Power BI. I’m looking for a solution for dynamically adjusting tree-map based on the value selected.
Right now I’m showing top 20 location using Top N filer option instead I want this to be dynamic say I want to see top 25 or 30 sites or say any number. how do I do it.
Basically I want to parameterize the select of top sites by any specified number (top 5 / 10 / 15 / 20 sites).
Please help….
Regards,
Sunil Kerody
Hi， @SKerody ；
Try it.
1.create a what-if parameter as a topn slicer.
2.create a top measure.
TOP =
var _rank= RANKX(ALLSELECTED(financials),CALCULATE(SUM(financials[ Sales]),ALLEXCEPT(financials,financials[Country])),,DESC,Dense)
return IF(_rank<=[Parameter Value],1,0)3.apply it into Treemap filter.
The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi， @SKerody ；
Try it.
1.create a what-if parameter as a topn slicer.
2.create a top measure.
TOP =
var _rank= RANKX(ALLSELECTED(financials),CALCULATE(SUM(financials[ Sales]),ALLEXCEPT(financials,financials[Country])),,DESC,Dense)
return IF(_rank<=[Parameter Value],1,0)3.apply it into Treemap filter.
The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
