Traversing Hierarchical Dimensions For Dimension-Based Visual Elements

Some embodiments provide a non-transitory machine-readable medium that stores a program executable by at least one processing unit of a device. The program renders a visualization that includes a first set of visual elements. The program further receives a request for measure values categorized according to the first level of dimension values in the first hierarchy of dimension values and a second level of dimension values in the second hierarchy of dimension values. The program also generates a query for a second set of data from the dataset. The program further sends the query to a computing system configured to manage the dataset. The program also receives the second set of data from the computing system. The program further renders a second set of visual elements. The program also replaces the first set of visual elements in the visualization with the second set of visual elements.