Showing Multiple Measures in TreeMap

[Anonymous]

Hi All,

Assume i have sales data for diffrent regions and i am visualizing it in TreeMap.

Can i Show both sales and % of total sales in the treemap square(as a datalabel)?

i tried but i can show either sales or % of sales but couln't show both. but i know we can show both in tooltip but my requirement is to show both in the chart so that we can see both the data

.

Thanks,

Raj

[v-yuta-msft · Accepted solution]

@Anonymous ,

I'm afraid this requirement can't be achieved in Treemap because measure can not be dragged to the details section and the details section can only contains one column/measure. 

So the workaround is to create a calculate column and create two treemaps as below:

 

Community Support Team _ Jimmy Tao

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