Forum Discussion
Dynamic TreeMap
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.
1 Reply
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.