Dynamic TreeMap

[SKerody]

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

[v-yalanwu-msft · Accepted solution]

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.