Q&A Power BI, No direct way to plot multilayer map

[Anonymous]

I am trying to plot a multilayer map in PowerBI using natural language processing. Let's say I write something like show total sales by state, district, postal code by map to show sales at the state level first then when I click on state drill it down to the district and so on. But whenever i write this query it changes the visualization to table type. I have tried it using geo hierarchy as well.

[v-jiascu-msft]

Hi @Anonymous,

Can you share the query you used?

Did you change the "data category" to proper type that the map can recognize?

Please also refer to #which-visualization-does-qa-use.

Best Regards,

Dale

[Anonymous]

All geography columns I used have respective geo data category like state as state or province city as city etc.

I have used following queries 

Search query: Show actual sales by state, city by map it is giving me city as legend in map chart with the state as location and actual sales as value field.

 

Query2:

Show actual sales by hierarchy by map.

I created geo hierarchy using state, city, street as combined power bi hierarchy and used in the query.

It shows the table with all correct columns.

But my requirement is to create a drillable chart using some query. That I am unable to achieve.