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
AparnaJ
Helper I
Helper I

Tree Map

Hi,

Created a treemap visual, screenshots below: 

 
 

Tree MapTree Map

 

Is there a way that I can sort by year. Current settings are below:

 

treemap settings.PNG

 

Please advise.

 

Thank you.

1 REPLY 1
dm-p
Super User
Super User

Hi @AparnaJ,

The treemap visual is designed to sort by descending value of measure (MS doc on sorting in general: refer to note about treemap not being sortable), so that the largest values appear first and smaller series cluster towards the bottom-right and are therefore easier to visually resolve quickly. This has come up a couple of times before, so here's some threads for further reading:

If it's a feature you want, you'll need to create an idea for it, or create a custom visual to do it. Probably not the answer you're after but hopefully this allows you to explore other means of visualising the data you're looking at. Have you determined if the treemap is actually correct for these data? What is the treemap trying to convey to the end user?

Regards,

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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