How to create a Interactive Dashboard of a Map

Hello everyone,

I wonder if this can be done in Excel, but

I was wondering if it is possible to create a interactive dashboard of a map.

For example:

I have a list of customers names and their respective street addres in one worksheet A

In another worksheet I want a map of Los Angeles.

I also have a set of slicers in which I can choose base off of ethnicity, gender, etc which is also in worksheet A respective for each customer.

How can I make it that when I choose Male for example, the map will highlight the customers in the map.

I hope that makes sense.

It seems pretty hard but wonder if it is possible.

i've seen it done when I was googling but I haven't found a good tutorial or step by step guide to do it.

Any help is appreciative.

HI,

You are correct it can be done in Power BI its an Office 365 Tool.
Attached the file i will try to do it for you. Thanks,

Ah, the help is appreciated, but

what is Power BI?

Do I need to have it?

Power BI is a Office 365 tool which is useful in creating all sorts of Dashboards/Charts.

Thanks,