Forum Discussion
Decomposition Tree - show top 10/5 nodes
Hi Community,
I am using the decomposition tree as one of my visuals. As you drill down through the nodes it tends to get crowded the further you go - focus mode does not help either.
Does anyone know if/how I could show the top 10 per node or show top 10 for one node and top 5 for the next node? I am only interested in seeing the top 10/5 not the whole list.
Example:
- Node 1: net sales
- Node 2: top 10 customers
- Node 3: top 5 products (bought by customer)
1 Reply
Hi Anonymous ,
You could use the TOP N filter or use the TOPN function. Please kindly refer to
Solved: TopN - Microsoft Power BI Community
TOP N Filter in Power BI with Zero DAX Code; Visual Level Filter - RADACAD
Power BI TOPN Function: Comprehensive Guide with 2 Examples - Learn | Hevo.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.