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

20. Dynamic Text and Dynamic Colour (Conditional Formatting)

By Last updated:

Report "jivant" vatla pahije – user ne Pune nivadla ki title madhe Pune disla pahije, target chukla ki rang lal jhala pahije. Ya module madhe fx button, dynamic titles, CONCATENATEX aani conditional formatting shikuya.

What you will learn in this module

  • Dynamic titles with measures and the fx button
  • Showing selected cities with SELECTEDVALUE and CONCATENATEX
  • Text boxes with dynamic values, smart narrative, and cards with dynamic labels
  • Conditional formatting: rules, gradient (colour scale), field value with a DAX colour measure
  • Background/font colour, data bars, icons, web URLs
  • KPI-based colouring (delivery time > 15 mins = red) and dynamic colours in bar charts

Live story: Red when late, green when on time

Suppose the Blinkit Pune manager wants late stores to turn red by themselves. She also wants the title to say "Sales for Pune — March 2025" when she picks Pune. This chapter adds dynamic titles and conditional formatting driven by measures.

All numbers in this story are fictional practice data.

Concepts in this chapter

  1. 20.1The fx Button
  2. 20.2Dynamic Titles with Measures
  3. 20.3Showing Several Selected Cities (CONCATENATEX)
  4. 20.4Text Box with Dynamic Values and Smart Narrative
  5. 20.5Cards with Dynamic Labels
  6. 20.6Conditional Formatting: Rules, Gradient and Field Value
  7. 20.7Data Bars, Icons and Web URLs
  8. 20.8KPI-based Colouring in Charts and Cards

The chapter recap is at the end of the last concept page.

Ravi Sir's Cards: 11 revision, interview and comparison cards for this chapter · मराठी cards