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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
perpor
Helper V
Helper V

Treemap - help - order with two values is possible?

I do not know if it is possible with the current version to create a treemap with two levels of values:

 

I would like a graph where the most external rectangles are sorted by an index1, and the most internal rectangles with index2.

 

It seems that with the current version, which accepts only one value as 'values', such as index2, the inner rectangles are ordered correctly, while the rectangles outside have an order that I do not understand

 

thank you

4 REPLIES 4
perpor
Helper V
Helper V

The two values are indices, values tha can not be summed up, eg. 5.61, 5.45, 5.22, 4.98, etc ... for the index of the most external level,
similar values for the most internal index.
The elements of the most internal level are hierarchically dependent on the external layer:

a11, a12, a13, etc. depend on A1
b11, b12, b13, etc. depend on B1
.....

And in the test chart I used the average of that index...

I mean there are currently two datasets, one for the top and one for the level
lower ones that contain the data, index1 in the first and index2 in the second,
even if the data type is the same, for index1 and index2, for example as sales,

values that are indexes anc can not sum up.
I would like to get this type of graph without having to restructure existing datasets
creating for example a unique index, which I think would solve the problem ...

Hi @perpor,

 

Can you please provide some sample data? I will try it if possible to achieve this.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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