Ravindra BagaleCourses & study guides

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

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.