Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am working on data with states and cities. I want to create a hierarchy like if i click on a particular state i need to go to the city in that state. Is it possible to overcome my problem by creating hierarchy? Can anyone please help me out on this.
Thanks in advance
Solved! Go to Solution.
Hi @Manikanth,
In your scenario, you can create a map visual, then place both State and City fields in Location property, drag a field to Size property. You can turn on drill down, click on any data point, it will drill down to the cities under corresponding state.
Best Regards,
Qiuyun Yu
Hi @Manikanth,
In your scenario, you can create a map visual, then place both State and City fields in Location property, drag a field to Size property. You can turn on drill down, click on any data point, it will drill down to the cities under corresponding state.
Best Regards,
Qiuyun Yu
Qiuyun,
In my case the "city" information is determined by Longitude and Latitude, and the "state" information is just the selection of some of these ones, so it is just a name. It is possible to drill up and down this information on a map? So that the "state" information sums the values of all these "city" and places the information on the map on the median point of these Longitude and latitude values? Or providing a Longitude and Latitude information of the "state"
Thank you in advance.
Hi Qiuyun Yu,
Thank you very much for the help. Your solution solved my problem 🙂
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |