20. Dynamic Text and Dynamic Colour (Conditional Formatting)
20.4 Text Box with Dynamic Values and Smart Narrative
Steps in Power BI – text box with values
- Insert › Text box. Type: "This period, total orders were ".
- Click + Value on the text box toolbar. In How would you calculate this value? type or pick
Total Orders. Set its Format and Name › Save. - Continue typing: " with an average delivery time of ", then + Value ›
Avg Delivery Time (mins), and " minutes." - The values update with slicers. Format fonts as usual.
Smart narrative / Narrative: Insert › Smart narrative (in newer versions, the Narrative visual, with Copilot where available and enabled). It generates a text summary of the page or visual, with key trends and values. You can edit the text and add your own values with + Value. Always read the generated text before publishing.
A measure-based narrative (full control):
Narrative Text =
"In " & [Selected Cities] & ", " & FORMAT([Total Orders], "#,##0") & " orders were delivered in "
& FORMAT([Avg Delivery Time (mins)], "0.0") & " minutes on average; "
& FORMAT([% Orders Delivered Under 10 Mins], "0.0%") & " arrived within 10 minutes."
Show it in a Card (Callout value) or a Card (new) with the category label off.
Ravindra Bagale's Tip
Friends, many students type a number into a text box and forget to update it next month. Insert dynamic values (measures) into the text box so the sentence updates with the data, and review the text of smart narratives before publishing. Never forget this.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students text box मध्ये number टाइप करतात आणि पुढच्या महिन्यात तो update करायला विसरतात. Text box मध्ये dynamic values (measures) टाका म्हणजे वाक्य data सोबत update होईल, आणि publish करण्याआधी smart narratives चा text तपासा. हे अजिबात विसरू नका.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students text box में number type कर देते हैं और अगले महीने उसे update करना भूल जाते हैं. Text box में dynamic values (measures) डालो ताकि वाक्य data के साथ update हो, और publish करने से पहले smart narratives का text check करो. यह बिल्कुल मत भूलना.