Visuals to use with hierarchy text

[positivist83]

Hi , I am trying to make visuals that shows a map of the region of a city.I will choose a city,it will show the map of region,in another table the cities of the region and one filter shows the region.But I can't select all the cities in one region.I  try to use ALL function or concatanated list but I am new to Power BI so I couldn't figure that out.

I would be really grateful if you can help,

Thanks in advance.

[v-alq-msft]

Hi, @positivist83 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[positivist83]

I couldn't find driil up option.All visuals must be in different area.

I will be really glad if you could send me pbix file.Icouldn't send pbix file so sending a printscreen

[v-alq-msft]

Hi, @positivist83 

Based on your description, I'd like to suggest you use Drill mode in a visual in Power BI . I created data to reproduce your scenario.

Table:

In the scenario, you can create a map visual, then place both 'State' and 'City' fields in Location property. You can turn on drill down, click on any data point, it will drill down to the cities under corresponding state. Or you can right-click the corresponding data point to drill up to the 'State' level.

Best Regards

Allan

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

[amitchandak]

@positivist83 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
If you are looking for a slicer then try

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/#_Hierarchic...
Appreciate your Kudos.