cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## Map visual: preventing piechart and showing data in tooltip

Hi all,

I have a table with partner companies which has the following columns (among others, that are irrelevant for this visual)

• painterName
• Phone number
• location (Zip Code (PLZ), in Germany)
• Status (e.g. "Active", "Interested", "Blacklist", etc.)

I would like to plot these partners on a map, where each partner company is depicted by a single bubble. The color of the bubble should indicate the status. Further, i would like the tooltip to show the Company name and phone number for each individual bubble.

I created the map (see below), but two things are going wrong:

1. Not every partner company is depicted by a single bubble, but some bubbles represent multiple partners. See the tooltip in the example. There are 4 painters at this location of which 3 are interested (yellow) and one is active (green). This is depicted as one pie chart which is 75% yellow and 25% green.

--> is it possible to depict this as four individual bubbles, each with their own color?

2. The tooltip is showing the count of paintername and phone, but not the actual value. I looked into this topic, which suggests a solution by creating a Measure with the VALUES function to display the relevant data in the tooltip. However, when i do this, i get an error (see second pic below), as the VALUES function returns a column of 4 values in one tooltip, rather than four tooltips with one value each. I think this problem will automatically be solved when each of the painters is depicted by a single bubble (question 1), but i might be off.

--> Any idea how to solve this?

maperror

1 ACCEPTED SOLUTION
Community Champion

@david2

Create a new column

partnersData = Table1[PartnerName] & "-" & Table1[Status] & "-" & Table1[phone]

Next create a measure:

PartnersInfo = CONCATENATEX(Table1,Table1[partnersData],"|")

Use this measure in tooltip area.

Lima - Peru
4 REPLIES 4
Employee

Hi david2,

Well, as the Map visual identify the location based on the postal code, so currently I don't think having the 3 people in the same location displayed in 3 bubbles.

For Question 2, I could think out a way to deal with that, which would need to know how the data table you stored for the locations and the partners.

For example, if the data table is somehow the structure below:

 Location People A 1 A 2 B 3 C 4 C 5

Then we may write a measure to show the names, when location contains more than one partner value, we concatenate the name string into one, with this the visual should be able to display the 3 partner names.

Partnername = CONCATENATEX(VALUES('Table'[Partner]),'Table'[Partner],",")

Put this measure into Tooltips.

If this is not working, please share your data model, and we will help to check.

Regards

Helper I

Thanks for the quick reply. I was already afraid that plotting 3 bubbles on the same location would not be possible, since 3they would overlap. I guess we'll have to start collecting a more detailed address of our partners anyway.

Regarding your answer on question 2, my table is structured as follows (simplified example):

Ideally, i would like the bubble on location 10001 to show something like "John - Active - 12313123; Pete - Interested - 12313123; Mike - Active - 12313123".

Any idea how to achieve that?

Best,

David

Community Champion

@david2

Create a new column

partnersData = Table1[PartnerName] & "-" & Table1[Status] & "-" & Table1[phone]

Next create a measure:

PartnersInfo = CONCATENATEX(Table1,Table1[partnersData],"|")

Use this measure in tooltip area.

Lima - Peru
Helper I

Works like a charm! Thanks @Vvelarde 🙂

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors