Forum Discussion
sorting treemap
No but they generally follow this pattern - largest values (on the right) to smallest values (on the left)
Hi,
I am looking for the same solution. Do you get any resolution for the same requirement?
Thanks.
Hi avinash726 ,
Did you ever find a solution for this? Or and alternative?
I want to use the coloured proportions of a treemap. But the rectangles need to be ordered by the names or numbers of the groups, not by size.
I know this is probably solved by you (@Caila), but if not and you're still looking for an alternative I did find one...sort of. Basically you'd need to be okay with having the rectangles all the same size, but they do sort!
So in my analysis, I wanted to use the treemap for the fiscal year only to add some color to the report. But, I had different numbers in each fiscal year and so it didn't sort it in year order. To get around that, I used the same field in both the Group and the Values field (group as fiscal year, values as count of fiscal year), and then it sorted it in ascending order. And now mine looks like this:Other BI tools allow sorting of 'Treemaps' known as Heatmaps. Come on Microsoft!
