Tableau to power bi migration. Looking for the following/similar visual to apply using PowerBI

[puneethjp]

Hi, 

Below are the two tables 1) master table ( from db-only one table) 2) StateDetails(new table created to map state names)
We are trying to migrate tableau report to power bi. Here are the sample visuals and related sample data posted under the visual. 
As per the visual 

1) Could you please help me with how to develop the similar visual with map visuals ( Tried Filled Map), to look similar like Tablueau report. On the below visual I tried tooltip added, when hover over can see the list of details. 
But, as per the tableau report, we need to display the names/values as show in image. (also need to include colors to it) 

2) Could you please recommend any external visual( free- pbi certified ) to use to display the same. 
Mapping: 
Model view:  Map region_name (master) with Region name (Statedetails) >> One tom many relationship

Drag and drop:

State under Location and  Zone Name under Legend for the below visual 

Power BI visual (developed) : Used tooltip to display relevent column data.But, client looking for something similar to tableau.


Tablueau sample visual 
Zone based visualRegion_based

Master table: (driven from db using SQL query) 

ZipCode	SalesGroup	Zone	Zone_Name	Region	Region_Name	VP_name	Countrycode	workcenternumber
92273	Service	D5	Is West	D5-10	Arizona	abc	US	D5-10-01
92251	Service	D5	Is West	D5-10	Arizona	abc	US	D5-10-01
92250	Service	D5	Is West	D5-10	Arizona	abc	US	D5-10-01
92249	Service	D5	Is West	D5-10	Arizona	abc	US	D5-10-01
92244	Service	D5	Is West	D5-10	Arizona	abc	US	D5-10-01
31836	Service	D2	Is South	D2-04	Atlanta	bcd	US	D2-04-01
31833	Service	D2	Is South	D2-04	Atlanta	bcd	US	D2-04-01
31827	Service	D2	Is South	D2-04	Atlanta	bcd	US	D2-04-01
03435	Service	D1	Is East	D1-10	Boston	qwe	US	D1-10-01
02780	Service	D1	Is East	D1-10	Boston	qwe	US	D1-10-01
02767	Service	D1	Is East	D1-10	Boston	qwe	US	D1-10-01
49682	Service	D3-07	Is Midwest	D3-07	Michigan	ert	US	D3-07-02
49680	Service	D3-07	Is Midwest	D3-07	Michigan	ert	US	D3-07-02
49676	Service	D3-07	Is Midwest	D3-07	Michigan	ert	US	D3-07-02

StateDetails

Region_Name	City	State
Arizona	Phoenix	AZ
Arizona	Phoenix	AZ
Arizona	Phoenix	AZ
Arizona	Phoenix	AZ
Arizona	Phoenix	AZ
Atlanta	Atlanta	GA
Atlanta	Atlanta	GA
Atlanta	Atlanta	GA
Boston	Boston	MA
Boston	Boston	MA
Boston	Boston	MA
Michigan	Detriot	MI
Michigan	Detriot	MI
Michigan	Detriot	MI

Appreciate your time and help 

Thanks and regards

Puneeth

[SamWiseOwl · Accepted solution]

Hi @puneethjp 

I used the built in Azure map to achieve this:

You may need to turn it on if using it for the first time in settings.

It isn't the pretiest but I created a new column called zone name which is equal to zone_name.

I used the Zone name and State as a location and Zone_name as the legend.

Turn on the bubble layer and drilldown to the bottom level.

I also had to use CountryCode as it didn't do what yours did, presumably because I am in the UK.

[puneethjp · Accepted solution]

Thank you @SamWiseOwl @Hemansi Appreciate your time and help.
@Hemansi I do not have latitude and logitude in my current table, also do not have any particular column to refer to define the size. 

[puneethjp]

Thank you for your help and time in solving the issue. I have some additinal requiement on the above mentioned issue we have. I now have got an approval to use azure maps. So, using it now. 
Currently we have only one table with following sample details. FYI: Table does not have lat or log or state name details.

Master table: (driven from db using SQL query) 

ZipCode	SalesGroup	Zone	Zone_Name	Region	Region_Name	VP_name	Countrycode	workcenternumber
92273	Service	D5	Is West	D5-10	Arizona	abc	US	D5-10-01
92251	Service	D5	Is West	D5-10	Arizona	abc	US	D5-10-01
92250	Service	D5	Is West	D5-10	Arizona	abc	US	D5-10-01
92249	Service	D5	Is West	D5-10	Arizona	abc	US	D5-10-01
92244	Service	D5	Is West	D5-10	Arizona	abc	US	D5-10-01
31836	Service	D2	Is South	D2-04	Atlanta	bcd	US	D2-04-01
31833	Service	D2	Is South	D2-04	Atlanta	bcd	US	D2-04-01
31827	Service	D2	Is South	D2-04	Atlanta	bcd	US	D2-04-01
03435	Service	D1	Is East	D1-10	Boston	qwe	US	D1-10-01
02780	Service	D1	Is East	D1-10	Boston	qwe	US	D1-10-01
02767	Service	D1	Is East	D1-10	Boston	qwe	US	D1-10-01
49682	Service	D3-07	Is Midwest	D3-07	Michigan	ert	US	D3-07-02
49680	Service	D3-07	Is Midwest	D3-07	Michigan	ert	US	D3-07-02
49676	Service	D3-07	Is Midwest	D3-07	Michigan	ert	US	D3-07-02

Need to replicate the following visuals. (below visuals are taken from tableau: Need to replicate the same on Powerbi

We need to add filter/slicer(dropdown) :

Zone name:

Has values Ex; Is west, is east, is south, is midwest etc.  
When this are selected the below images should show up. I am currently using azure maps. 
Please let me know what can we add under: Location field, Legend; etc  

Indivial zone names should be filled with colors repectively. 

Scerario 2 Page: Region 
Has filters: Zone Name: Ex Is East (selected)
Region(dropdown): ex: D1-01, D1-03, D2-06 etc. 
Region Name: ex : Boston, Conneticut, DC/Baltimore etc. (selected) rest unselected. 

The following visual should be replicated. Lets say I select 
Zone name: Is East

Region: ALL

Region Name: Boston, Conneticut, DC/Baltimore etc. (selected) rest unselected. 
If you carefully observe the image below: East region should show up, with every including boston, connecticut selected and not selected are represented with different colors. So, all of east with region names should be highleted with different colors. Please help me with this hierearchy how to replicate this. 

Secenario 3 Page: Workcenter
Has filters:

Zone Name(dropdown): Ex Is East. (selected)
Region Name:(dropdown) ex : Boston, Conneticut, DC/Baltimore etc. (All selected)

Work center number (dropdown): ex: D5-04-02, D5-018-01,etc.(All selected) 
The below visual should be generated(pardon me for image) On the left you have slicer and image you every For every zone name (west) region name selected all work center numbers are assinged different colors. Could you please help me with this hirearchy too. Which coloumns from above only master table which we have needs to selected as values so we get this visuals. (Note: we do not have lat or log or state details here- only have columns which are in the master table. 

Appreciate your time and all your help. Please consider above three scenerios. 

Thanks and regards

Puneeth

[Anonymous · Accepted solution]

Hi,Hemansi and SamWiseOwl ,thanks for your concern about this issue.

Your answers are excellent!
And I would like to share some additional solutions below.
Hello,@puneethjp .I am glad to help you.
Based on your description: you don't have latitude/longitude data, Azure Maps as suggested by SamWiseOwl may be a more flexible option.
I hope the following documentation will help you find the right Map for you in Power BI more quickly

URL:
Power BI Maps: Types, How to Create and Use Cases | Coupler.io Blog
Geocoding in Azure Maps Power BI visual - Microsoft Azure Maps | Microsoft Learn
Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn
Get started with Azure Maps Power BI visual - Microsoft Azure Maps | Microsoft Learn

Some map visuals can also be found in the vsiual store in Power BI Desktop.
You can find the right visuals for your actual data format and needs.
Like this:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[puneethjp · Accepted solution]

Thank you @SamWiseOwl @Hemansi Appreciate your time and help.
@Hemansi I do not have latitude and logitude in my current table, also do not have any particular column to refer to define the size. 

[SamWiseOwl · Accepted solution]

Hi @puneethjp 

I used the built in Azure map to achieve this:

You may need to turn it on if using it for the first time in settings.

It isn't the pretiest but I created a new column called zone name which is equal to zone_name.

I used the Zone name and State as a location and Zone_name as the legend.

Turn on the bubble layer and drilldown to the bottom level.

I also had to use CountryCode as it didn't do what yours did, presumably because I am in the UK.

[Hemansi]

Hello,

You can try using the icon map external visual. It does have a lot of flexibility when producing what you require.

https://www.icon-map.com/