Forum Discussion
Map restrictions in Power BI difficult to plot
Hi,
My dataset is something like this :-
| County | Value | Walmart_Address | Type |
| Allen, Kansas | 5 | 2200 N State St, Iola, KS 66749 | A |
| Anderson, Kansas | 5 | ||
| Atchison, Kansas | 5 | ||
| Barber, Kansas | 5 | ||
| Barton, Kansas | 5 | 3503 10th St, Great Bend, KS 67530 | A |
| Bourbon, Kansas | 5 | ||
| Brown, Kansas | 5 | ||
| Butler, Kansas | 5 | ||
| Chase, Kansas | 5 | ||
| Chautauqua, Kansas | 5 | ||
| Cherokee, Kansas | 5 | ||
| Cheyenne, Kansas | 1 | ||
| Clark, Kansas | 4 | ||
| Clay, Kansas | 5 | ||
| Cloud, Kansas | 5 | ||
| Coffey, Kansas | 5 | ||
| Comanche, Kansas | 5 | ||
| Cowley, Kansas | 5 | ||
| Crawford, Kansas | 5 | ||
| Decatur, Kansas | 1 | ||
| Dickinson, Kansas | 5 | ||
| Doniphan, Kansas | 5 | ||
| Douglas, Kansas | 5 | ||
| Edwards, Kansas | 5 | ||
| Elk, Kansas | 5 | ||
| Ellis, Kansas | 5 | 4301 Vine St, Hays, KS 67601 | A |
| Ellsworth, Kansas | 5 | ||
| Finney, Kansas | 3 | 3101 E Kansas Ave, Garden City, KS 67846 | B |
| Ford, Kansas | 4 | 1905 N 14th Ave, Dodge City, KS 67801 | B |
| Franklin, Kansas | 5 | ||
| Geary, Kansas | 5 | ||
| Gove, Kansas | 2 | ||
| Graham, Kansas | 1 | ||
| Grant, Kansas | 4 | ||
| Gray, Kansas | 4 | ||
| Greeley, Kansas | 3 | ||
| Greenwood, Kansas | 5 | ||
| Hamilton, Kansas | 3 | ||
| Harper, Kansas | 5 | ||
| Harvey, Kansas | 5 | ||
| Haskell, Kansas | 4 | ||
| Hodgeman, Kansas | 3 | ||
| Jackson, Kansas | 5 | ||
| Jefferson, Kansas | 5 | ||
| Jewell, Kansas | 5 | ||
| Johnson, Kansas | 5 | ||
| Kearny, Kansas | 3 | ||
| Kingman, Kansas | 5 | ||
| Kiowa, Kansas | 5 | ||
| Labette, Kansas | 5 | ||
| Lane, Kansas | 3 | ||
| Leavenworth, Kansas | 5 | ||
| Lincoln, Kansas | 5 | ||
| Linn, Kansas | 5 | ||
| Logan, Kansas | 2 | ||
| Lyon, Kansas | 5 | 2301 Industrial Rd, Emporia, KS 66801 | B |
| Marion, Kansas | 5 | ||
| Marshall, Kansas | 5 | ||
| McPherson, Kansas | 5 | ||
| Meade, Kansas | 4 | ||
| Miami, Kansas | 5 | ||
| Mitchell, Kansas | 5 | ||
| Montgomery, Kansas | 5 | ||
| Morris, Kansas | 5 | ||
| Morton, Kansas | 4 | ||
| Nemaha, Kansas | 5 | ||
| Neosho, Kansas | 5 | ||
| Ness, Kansas | 3 | ||
| Norton, Kansas | 1 | ||
| Osage, Kansas | 5 | ||
| Osborne, Kansas | 5 | ||
| Ottawa, Kansas | 5 | ||
| Pawnee, Kansas | 5 | ||
| Phillips, Kansas | 5 | ||
| Pottawatomie, Kansas | 5 | ||
| Pratt, Kansas | 5 | ||
| Rawlins, Kansas | 1 | ||
| Reno, Kansas | 5 | ||
| Republic, Kansas | 5 | ||
| Rice, Kansas | 5 | ||
| Riley, Kansas | 5 | ||
| Rooks, Kansas | 5 | ||
| Rush, Kansas | 5 | ||
| Russell, Kansas | 5 | ||
| Saline, Kansas | 5 | ||
| Scott, Kansas | 3 | ||
| Sedgwick, Kansas | 5 | ||
| Seward, Kansas | 4 | 250 E, Tucker Rd, Liberal, KS 67901 | C |
| Shawnee, Kansas | 5 | ||
| Sheridan, Kansas | 1 | ||
| Sherman, Kansas | 1 | 2160 C0mmerce Rd, Goodland, KS 67735 | C |
| Smith, Kansas | 5 | ||
| Stafford, Kansas | 5 | ||
| Stanton, Kansas | 4 | ||
| Stevens, Kansas | 4 | ||
| Sumner, Kansas | 5 | ||
| Thomas, Kansas | 1 | 115 W Willow St, Colby, KS 67701 | C |
| Trego, Kansas | 2 | ||
| Wabaunsee, Kansas | 5 | ||
| Wallace, Kansas | 2 | ||
| Washington, Kansas | 5 | ||
| Wichita, Kansas | 3 | ||
| Wilson, Kansas | 5 | ||
| Woodson, Kansas | 5 | ||
| Wyandotte, Kansas | 5 |
Now I want to display counties and Walmart on one map. How can I do this? The counties are grouped by "Value" and walmart by "type". I am unable to plot this on one map (Check attachments). Any solutions or workarounds?
2 Replies
v-jiascu-msftMicrosoft Employee
Hi Anonymous,
How about the workaround that adds the Walmart Address as legend? If there is a Walmart, the color will be different.
Best Regards,
Dale