Ravindra BagaleCourses & study guides मराठी Track your progress

29. Practice Exercises and Final Assignment

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

By Last updated:

  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.

Practice files (fictional): visuals_orders_apr_may_2026.csv, column_vs_measure_orders.csv

Hints
  • Test with no selection, one and many selections.
Solutions (checked on the practice files)
  1. "Sales – " & SELECTEDVALUE(Orders[Platform], "All platforms") → Sales – Blinkit when Blinkit is selected.
  2. With Pune and Nashik selected: "2 cities selected"; with nothing: "All cities".
  3. Narrative example: May sales ₹1,200, up 33.3% on April.
  4. Store averages: Gangapur 14.0, Kothrud 12.0, Baner 12.0, College Road 10.0, Rajarampuri 7.0 – none is above 15, so no red bar; with a threshold of 11 three bars turn red.
  5. Data bars on Total Sales; icons by rules; set the URL column's data category to Web URL.
  6. City: 850/800/450; Platform: 1,100/1,000; Category: 1,050/650/400.
  7. Both give the same values; field parameters also keep each measure's format.
  8. Projected discount at +10% on column_vs_measure_orders.csv: ₹150 × 1.1 = ₹165.
  9. N = 3 stores: Kothrud ₹650, College Road ₹500, Rajarampuri ₹450.
  10. All five stores ranked slowest first: Gangapur, Kothrud/Baner, College Road, Rajarampuri.
  11. Last 1 months (calendar) = the whole previous month; last 1 months = rolling 30-ish days up to today.
  12. Sync Platform with Visible ticked only on page 1.
  13. Edit interactions › None on the card: it stays ₹2,100.
  14. Lock and hide in the Filters pane; format filter cards in the Format pane.

Ravindra Bagale's Tip

Friends, many students test dynamic titles and colours with only one selection. Test with no selection, one selection and several selections, because that is where most dynamic measures break. Clear?