14. Visuals and Their Formatting
14.22 Small Multiples and Visual Calculations (Quick Look)
- Small multiples: drag City into the Small multiples well of a line or column chart to get one mini chart per city (Pune, Solapur, Nashik, Sambhaji Nagar, Kolhapur, Nagpur) with shared axes. Format with Visual › Small multiples (layout rows/columns, titles, borders).
- Visual calculations: select a visual › Home › New visual calculation to write a calculation that uses only the visual's data, e.g.
Running Orders = RUNNINGSUM([Total Orders]). They are good for simple running totals and percent-of-total without adding measures to the model.
Ravindra Bagale's Tip
Mitrano, khup students create six copies of the same chart, one per city, instead of using small multiples. Put City in the Small multiples well so all charts share axes and formatting. Keep the number of panels small enough to stay readable. Ha niyam lakshat theva.