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
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 Power BI update to learn about new features.
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.
