Forum Discussion
Helper IIIHow to set level filter on Slicer?
I have a set of large data this just example.
| Asia | |||
| Thailand | Singapore | Malaysia | Vietnam |
| Bangkok | Kuala Lumpur | Ho Chi Min | |
| KhonKean | Malaka | Hanoi | |
| ChingMai | |||
| ChiangRai | |||
| Europe | |||
| Geramany | Netherland | France | |
| Munic | Amsterdam | Nice | |
| Frankfurt | Paris | ||
| Bodox |
So what I want is Filter levels such as.....
Level1(Continent)->Level2(Country)->Level3(City)
The result shows as Continent(Asia and Europe) as default and when someone else clicks on the name such as Asia, The result is country(Thailand, Malaysia, Vietnam, and Singapore. After select country then the city will be shown.
How to make it happen in Power BI? Do I have to use DAX or Slicer? Could you please tell me?
Thank you.
2 Replies
Seward12533Solution Sage
Check the visual store. There a number that iwll meet your needs. My favorite is the Drill Down Donut but unless you pay for the premium version you get an watermark. Another would be the hierachical slicer.
Note will be much easier if you have a data structure like this. Fact Table with information by City and lookup table to map City to Country and Continent which are related by City in the relationship tab.
City Data 1 Data2 Data3 … Frankfurt Value Value Value … Country Lookup Table
Continent Country City Europe Germany Frankfurt Europe Germany Stutgart …. 
v-huizhn-msftMicrosoft Employee
Hi saranp780,
Please keep a close eye on the following idea and it will be added in the future.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6795566-slicer-hierarchy
Best Regards,
Angelia