20. Dynamic Text and Dynamic Colour (Conditional Formatting)
20.5 Cards with Dynamic Labels
- Card (classic): turn Category label off, and turn General › Title on with fx → a measure such as
"Orders – " & [Selected Platform]. - Card (new): each callout has a Label with fx, and Reference labels can show a second measure such as
[Orders MoM %]with its own dynamic colour. - Arrow text for change:
Orders MoM Label =
VAR chg = [Orders MoM %]
RETURN IF(ISBLANK(chg), "–", IF(chg >= 0, "▲ ", "▼ ") & FORMAT(ABS(chg), "0.0%") & " vs last month")
Ravindra Bagale's Tip
A common mistake with cards is a label that says "Total Sales" when a slicer has filtered it to one city and one week. Use a dynamic label measure for the card title or category label, so the user always knows what the number covers. Keep this in mind!
Ravindra Bagale's Tip – मराठी
Card मधली एक common चूक म्हणजे slicer ने एक city आणि एक आठवड्यापुरता filter केलेला असतानाही label "Total Sales" असं सांगतो. Card title किंवा category label साठी dynamic label measure वापरा, म्हणजे number कशाचा आहे हे user ला नेहमी कळेल. लक्षात ठेवा!
Ravindra Bagale's Tip – हिंदी
Card की एक common गलती है label का "Total Sales" कहना जबकि slicer ने उसे एक city और एक हफ़्ते तक filter कर दिया है. Card title या category label के लिए dynamic label measure इस्तेमाल करो, ताकि user को हमेशा पता रहे कि number किसका है. ध्यान रखना!