29. Practice Exercises and Final Assignment

29.10 Modules 20–22: Dynamic Text and Colour, Dynamic Charts, Filters and Slicers

By Ravindra Bagale · Last updated: 25 September 2026

1. Create a dynamic title showing the selected platform and month.
2. Create a Selected Cities measure with CONCATENATEX that shows "All cities" or "N cities selected".
3. Write a narrative measure and show it in a card; add a text box with two + Value items.
4. Colour store bars red when Avg Delivery Time > 15 minutes using a field-value colour measure.
5. Add data bars, traffic-light icons (Rules) and a Web URL column to a store table.
6. Create a field parameter to switch between Total Sales, Total Orders and Avg Delivery Time, and another to switch the axis between City, Category and Payment Mode.
7. Rebuild the metric switch with a disconnected table + SWITCH and compare both methods.
8. Create a what-if parameter Discount Change % and a measure showing projected discount cost.
9. Build a dynamic Top N products chart with a slider (1–20).
10. Apply a Top N filter to show the 5 slowest dark stores by Avg Delivery Time.
11. Add a relative date filter "last 1 months (calendar)" and explain how it differs from "last 1 months".
12. Build tile, dropdown, between and hierarchy slicers; sync Platform across all pages (visible only on page 1).
13. Use Edit interactions so the "All platforms" card ignores the Platform slicer.
14. Lock a page filter State = Maharashtra and hide a filter excluding test stores. Format applied filter cards in yellow.