20. Dynamic Text and Dynamic Colour (Conditional Formatting)
20.7 Data Bars, Icons and Web URLs
| Option | Steps | Example |
|---|---|---|
| Data bars | Field drop-down › Conditional formatting › Data bars › positive/negative colours, axis, Show bar only | In-cell bars for Total Orders per dark store |
| Icons | Conditional formatting › Icons › Format style Rules or Field value › icon layout (left/right of data, icon only), alignment, Style (arrows, traffic lights, flags) | ▲/▼ for Orders MoM %; traffic lights for delivery time |
| Web URL | Conditional formatting › Web URL › based on a column with links | Store SOP link; set Data category Web URL on the column |
Icons
For icons, the Rules style with a preset icon set (arrows or traffic lights) is the easiest. Udaharan mhanje, Orders MoM % > 0 → green up arrow, < 0 → red down arrow. Field value icons are also possible, pan the measure must return the exact icon names that Power BI expects.
Ravindra Bagale's Tip
Remember one thing: data bars on a column with negative values or huge outliers can make the other bars invisible. Set the minimum and maximum values explicitly. For icons, add a legend or a note so users know what each icon means. Don't worry – after doing it two or three times, it becomes a habit.
Ravindra Bagale's Tip – मराठी
एक गोष्ट लक्षात ठेवा: negative values किंवा खूप मोठे outliers असलेल्या column वर data bars लावले तर बाकीचे bars दिसेनासे होऊ शकतात. Minimum आणि maximum values स्पष्टपणे set करा. Icons साठी legend किंवा note जोडा म्हणजे प्रत्येक icon चा अर्थ users ना कळेल. घाबरू नका, दोन-तीन वेळा केलं की सवय होते.
Ravindra Bagale's Tip – हिंदी
एक बात याद रखो: negative values या बहुत बड़े outliers वाले column पर data bars लगाने से बाकी bars दिखना बंद हो सकते हैं. Minimum और maximum values साफ़-साफ़ set करो. Icons के लिए legend या note जोड़ो ताकि users को हर icon का मतलब पता रहे. घबराओ मत, दो-तीन बार करने पर आदत हो जाती है.