Forum Discussion
can't drill down to specific level
My data has three levels and I'd like to drill down to locations (on Level 06) under "SULAWESI TENGAH All"
But when I clicked on "SULAWESI TENGAH All" point, it goes to "Level 05 and Level 06" instead of "Level 06"
If I "Switch to the next level" (which brings me to Level 07) then goes back up (using "Drill Up"), it DOES bring me to "Level 06"
So, how to go to "Level 06" in the first place ?
10 Replies
- lbendlin
Super User
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi Ibendlin
What I need is this :
I start with "SULAWESI TENGAH All" which is on Level 05
Then I need to see on Map all Locations (on Level 06) under "SULAWES TENGAH All"
How do i do that ? Thank you
Table view :
Level 05 L5 LAT L5 LONG Level 06 L6 LAT L6 LONG Level 07 L7 LAT L7 LONG Nett Weight SULAWESI TENGAH All -1.5013 121.4678 LUWUK -0.93737 122.793 LUWUK -0.93737 122.793 25190 SULAWESI TENGAH All -1.5013 121.4678 PALU ALL -0.89665 119.8717 AMPANA -0.86672 121.5855 560 SULAWESI TENGAH All -1.5013 121.4678 PALU ALL -0.89665 119.8717 DONGGALA -0.68055 119.6252 49080 SULAWESI TENGAH All -1.5013 121.4678 PALU ALL -0.89665 119.8717 PALU -0.895 119.8594 137220 SULAWESI TENGAH All -1.5013 121.4678 PALU ALL -0.89665 119.8717 POSO -1.4 120.75 23310 SULAWESI TENGAH All -1.5013 121.4678 PALU ALL -0.89665 119.8717 TOLI - TOLI / BUOL 1.154848 121.4125 30920 - lbendlin
I would go with this data structure
Name LAT LON Parent Weight SULAWESI TENGAH All -1.5013 121.468 266280 LUWUK ALL -0.93737 122.793 SULAWESI TENGAH All 25190 PALU ALL -0.89665 119.872 SULAWESI TENGAH All 241090 LUWUK -0.93737 122.793 LUWUK ALL 25190 AMPANA -0.86672 121.586 PALU ALL 560 DONGGALA -0.68055 119.625 PALU ALL 49080 PALU -0.895 119.859 PALU ALL 137220 POSO -1.4 120.75 PALU ALL 23310 TOLI - TOLI / BUOL 1.15485 121.413 PALU ALL 30920
i didn't see hierarchy and drill up/down feature on your pbix file.
like i mentioned in the first post, i need to display data on the map which i can drill up/down between three-level hierarchy locations
hope i make myself clear
- lbendlin
see attached
I apologize I didn't make it clear from the start. Hope the following scenario make it more clear :
I start with one bubble on the map (Level 05: SULAWESI TENGAH ALL)
When I drill down on that bubble, I expect the view to change to Level 06 and see TWO bubbles (one for LUWUK, one for PALU ALL)
At this point I have two choices
1. If I choose to drill down on PALU ALL, I expect to change to Level 07 view and see 5 bubbles (not 6 but 5) ie. AMPANA, DONGGALA, PALU, POSO and TOLI-TOLI
2. if I choose to drill down on LUWUK, the view will also change to Level 07 BUT I expect to see ONE bubble ie. LUWUK [of Level 07]
The data sample might not be ideal, but I hope steps above describe what I want to achieve. Thank you for bearing with me, my English isn't good.
