21. Dynamic Charts: Field Parameters, What-if and Dynamic Top N
21.6 Chart/Table Toggle (Recap)
A classic dynamic-chart pattern is two visuals in the same place, shown/hidden with bookmarks and buttons. Module 19.4 has the full steps. Combine it with field parameters: the chart and the table both use Metric Selector, so one slicer drives both views.
Practice task
He bagha: build a "Dynamic Explorer" page: a Metric Selector (Sales, Orders, AOV, Avg Delivery), an Axis Selector (City, Category, Payment Mode, Order Hour), a Top N slider for the bar chart, a what-if slider for Target Delivery Minutes with % Orders Under Target, and a chart/table toggle. Add a dynamic title that names the metric and axis chosen.
Ravindra Bagale's Tip
Mitrano, khup students keep both the chart and the table visible behind each other, which slows the page karan both still run queries. Hidden visuals don't run queries, so make sure the bookmark actually hides one of them. Bilkul visru naka.
Thodkyaat sangaycha tar (quick recap)
Measures badlayla field parameter, scenarios sathi what-if, aani Top N sathi RANKX kiwa Top N filter. Single select vapra aani sort check kara. Aata pudhe jaauya filters aani slicers kade.