How to get "Don't Summarize" option

[neelofarshama]

Hi,

I have a column "Promotion_Id" its datatype is Whole number.

I have to create a tree map displaying promotion_id with date like below, when i am trying to create the same in power bi, the values data is getting aggregated, i dont want my values to get aggregated the option "Dont Summerize" is not being displayed.

Can anyone please help me with this or suggest me some alternative.

[v-yiruan-msft]

Hi @neelofarshama ,

Please select the field "Promotion_Id", then navigate to "Columns tool" ribbon and set Summarization option as "Don't summarize". And the field "Promotion_Id" be used in Group or Values part of treemap?

The following ones are some documentations about the treemap, please review them if you need to know more about treemap.

Treemaps in Power BI

How to Create Power BI Treemap – 8 Simple & Easy Steps

Best Regards

Rena

[amitchandak]

@neelofarshama , You can not have summarized values or all values group as ungrouped in Treemap visual

[Anonymous]

Hello @neelofarshama ,

in your treemap, just place your promotion_id field into the group field in the chart and the amount in the values field:

[neelofarshama]

Thank you for the reply, i tried using your suggeestion but i am not geeting required output, please find my screenshot below.