Balachandra Srinevasalu on 13 Mar 2024 11:03:22
Recently, I've been involved in a project where I aimed to drill down from Indian States to Indian Districts. Unfortunately, we encountered a limitation with our map visualization tool, preventing us from executing the desired drill-through. While exploring alternatives, I discovered that the Shape Map with a JSON file can only accommodate one location/column.
Further research led me to the Drilldown Choropleth option, which seemed promising. However, it also necessitates a JSON file, introducing dependencies that complicate updates to state or district names. Additionally, manual mapping of JSON names with database/table values becomes necessary.
Furthermore, when using a legend in the Drilldown Choropleth and selecting slicer values, the legend color dynamically changes. This behavior raises uncertainty whether it's a bug or an intended feature.
Given these challenges, I propose an idea/request: Why not have Microsoft develop an in-built India map to bypass the need for custom visuals and external files like JSON? Such an integrated solution would streamline our processes and mitigate the complexities associated with external dependencies