Map visual with drill down

Power BI
1

For United States, I would like to drill down to USA -->State -->Zip Code, for international, I would like to go country -->city -->zip code.

Please refer attachment for sample data.
image sample_data.csv (702 Bytes)

2

Hi, could you provide a pbix including international addresses. Interesting, you can drilldown using a hierarchy so you need multiple hierarchies to achieve this.
Paul.

3

@mrommala Hey Mate,
You can use this method.

image
image1910×871 71.3 KB

from 2 : you can go down in list . country -->city -->state -->zip code.

You can remove state from row if you do not want to drill down to state level

Thank you @Paul @mrommala

4

Hello @mrommala,

Thank You for posting your query onto the Forum.

Well, I don’t think so this type of conditional drilling is available where if it’s USA then Country >> State >> Postal Code and for Other Countries, Countries >> City >> Postal Code. This is because under the “Location” section we don’t individual sections available for such types. But what you can simply do is use the “Bookmarks and Buttons” technique for this type of condition. Below are the screenshots provided for the reference for both the conditions -

A. USA Visual -

1.1. Overall USA Visual

1. USA Overall Visual
1. USA Overall Visual1393×800 126 KB

1.2. USA >> States Visual

2. USA States Visual
2. USA States Visual1386×796 194 KB

1.3. USA >> States >> Zip Codes Visual

3. USA Zip Codes Visual
3. USA Zip Codes Visual1385×793 189 KB

Similarly, now for other countries, replace the States field with the Cities field -

B. Other Countries Visual

1.1. Other Countries Visual

4. Other Countries Visual
4. Other Countries Visual1393×790 184 KB

1.2. Other Countries >> Cities Visual

5. Other Countries and Cities Visual
5. Other Countries and Cities Visual1380×789 183 KB

1.3. Other Countries >> Cities >> Zip Codes Visual

6. Other Countries, Cities and Zip Codes Visual
6. Other Countries, Cities and Zip Codes Visual1391×515 107 KB

I’m also attaching the Excel as well PBIX file of the working for the reference.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Map Visual With Drill Down - Harsh.xlsx (9.9 KB)

Map Visual With Drill Down - Harsh.pbix (27.9 KB)

1 Like
5

Hi @mrommala, we’ve noticed that no response has been received from you since the 23rd of October. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

6

@Harsh, @samharishk, @Paul , @EnterpriseDNA
Thank you very much for your valuable time.

I followed below approach to fulfill my requirement.

Initially, I have created calculated column (sub_location) as below:
sub_location = IF(‘rpt spt_client_product_detail’[country]=“UNITED STATES”,‘rpt spt_client_product_detail’[state],‘rpt spt_client_product_detail’[city])

and then used this hierarchy in map visual country–> sub_location–> zip_code.

Regards,
Madhan Rommala

7

Hi, if that works to solve your question, great. Initially I did the same thing, albeit in PowerQuery, but I did not realise that this was what you were looking for and went to see if multiple hierarchies would be the answer.

8

Hi @mrommala, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!

9

Harsh,
I had to dig deep in my libraries to find another solution, that I had at the back of my mind. It is not mine and I do not recall who posted this.Variable Legend.pbix (63.3 KB)
Also check

Paul

1 Like