I'm building a financial dashboard in Databricks using a Pivot visualization with two dimensions in the row hierarchy.
The drill-down works as expected, but I'm having a usability issue: every time the view is loaded, both dimensions are fully expanded.
For this type of financial report, I'd prefer the initial state to be collapsed to the first level, so the user can click + on the items they want to explore, instead of having to click, repeatedly to close the hierarchy.
I couldn't find a setting that controls the initial expand/collapse state of the Pivot visualization.
Is there a configuration for this, or is there another way to make the hierarchy start collapsed by default?
Thanks!
Dados & BI ยท SQL | Python/PySpark | Databricks | Power BI