Forum Discussion

BBeresford's avatar
BBeresford
New Member
1 year ago
Solved

PowerBI Desktop Map Legend List

Hi all, 

I'm creating a map to show which countires we sell certain products. 

There are multiple products per country. 

 

I have the location as a column called "Country" and also have these countries as a "Latitude" and "Longitude" in a table connected by a "Country PK". 

 

The set up of the table is so that each product is on a separate row. 

BulkID   | Country

ABC01   |   Poland

ABC01   |   Hungary

ABC01   |   Sweden

ABC02   |   Hungary

 

I want it to be where when you hover over a country a list appears of all the products that are approved. 

The pie chart is too small to be able to select each slice and discover which products are sold there. 

 

 

To add a tool tip requires an aggregate of the BulkID so this won't work. I don't want a count / sum, I want the list.

 

Any ideas on how it is possible?

Thanks in advance.

  • Hi BBeresford , I suggest you create a custom tool tip page. This way you can set the filters and visuals displayed in the tool tip page exactly as you like.

4 Replies

  • VAMI's avatar
    VAMI
    Advocate I

    Hi BBeresford , I suggest you create a custom tool tip page. This way you can set the filters and visuals displayed in the tool tip page exactly as you like.

  • v-kathullac's avatar
    v-kathullac
    Community Support

    Hi BBeresford  ,

    we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

    Regards,

    Chaithanya.

  • v-kathullac's avatar
    v-kathullac
    Community Support

    Hi @BBeresford  ,

    we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

    Regards,

    Chaithanya.

  • v-kathullac's avatar
    v-kathullac
    Community Support

    Hi @BBeresford  ,

    we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

    Regards,

    Chaithanya.