Forum Discussion
Re-ordering a Filtered Treemap
Hello,
I have a a tree map showing sales by sales person, which correctly orders the treemap by size.
Each individual sale also has a field stating which country the sale was made in. When I change the country filter, the values in the treemap change, but the squares in the treemap do not change size or order.
For example, the #1 sales person sells £1m, all in India. If I remove India in the filters, they now correctly display in the treemap is £0 sales, but remain the largest square at the top-left of the treemap. Should this dynamically re-size/re-order?
Many thanks,
Mike
oops, for some reason i thought you could, please accept my apologies, but now that we have established that you can't.
what measure are you using, the calculation, is it something you have coded yourself or is it drag and drop, also have you edited any of the interactions between the visuals?
5 Replies
as far as i know it should, are you able to share your pbix or at least show screen shots of you visuals and measure calculations
You can see from this image that the pink square in the top-left is the largest in total. When I select UK on the map on the left, the values change (so the pink square decreases to £22k), but the ordering doesn't change:
