Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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 s...
Need Help
  • amitchandak's avatar
    amitchandak
    4 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

amitchandak's avatar
amitchandak
Super User
4 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
    4 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]

    )