Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

"Explain by" setting in Decomposition tree

Hi All, I am using decomposition tree view in power Bi desktop v2.84 version. I have a list of columns (50) which I have under "Explain by" setting of decomposition tree view. The problem is when I am clicking on "+" sign in view to select the column, I am not able to see all the columns in popup window as there is no scroll bar to scroll & select the needed column field. Is there any way to have the scroll bar in pop up window or a way to search & select the column ?

1 ACCEPTED SOLUTION
v-deddai1-msft
Community Support
Community Support

Hi @Anonymous ,

 

I didn't find any option for showing all columns . It is known limitation for Decomposition tree. The maximum number of levels for the tree is 50. Maximum number of data points that can be visualized at one time on the tree is 5000. We truncate levels to show top n. Currently the top n per level is set to 10.

 

For more details, please refer to https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-decomposition-tree

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

View solution in original post

4 REPLIES 4
azizanuh
New Member

Hello, I encountered the same issue. I have locked the levels and it is not changing now. Thank you.1.jpg

v-deddai1-msft
Community Support
Community Support

Hi @Anonymous ,

 

I didn't find any option for showing all columns . It is known limitation for Decomposition tree. The maximum number of levels for the tree is 50. Maximum number of data points that can be visualized at one time on the tree is 5000. We truncate levels to show top n. Currently the top n per level is set to 10.

 

For more details, please refer to https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-decomposition-tree

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Pragati11
Super User
Super User

Hi @Anonymous ,

 

Can you add a screesnhot please how it is coming at your end?

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

amitchandak
Super User
Super User

@Anonymous , I doubt, Just check arrow keys can help

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.