Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Bubble map with multiple measures

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,

 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , 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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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]

      )

  • Angela_AMBC's avatar
    Angela_AMBC
    New Member
    3 years ago

    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