Bubble map with multiple measures

[DivyaReddy]

Dear PBI enthusiasts!

I have a country, two calulated measures Profits and Losses and a lot of other fields and the dataset is too large. How do I do a bubble map with these fields where I have to show Profits in Green bubble, Losses in Red buble and the sizes of the bubble depends on the value of the amounts. 

Thank you in advance,

[Angela_AMBC]

Hi, I have the same question, I would like to represent data variation, so I want to have one bubble for one period and other one for the next period. How could I represent two bubbles for the same city? 

Thanks

[amitchandak · Accepted solution]

@DivyaReddy , Create a calculation group and use the name(column of calculation group) on details

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

[DivyaReddy]

Thank you @amitchandak . I was thinking more like creating a table with SUMMARIZE and use that - but not able to fine tune it. 

E.g.: 

CountryMapFields = SUMMARIZE(

Table1,Table1[Country],

"Profits",'MeasuresTable'[Profits],

"Losses",'MeasuresTable'[Losses]

)