📈 Power BI Tables | Add Up 🔼 and Down 🔽 Arrows for Trend Indicators

 Up and Down arrows in Power BI tables are powerful visual cues for showing performance trends—great for KPIs like Sales Growth, Profit Change, or YoY comparisons.

🧩 Why Use Arrows?

🔹 Improve visual storytelling
🔹 Instantly show increase or decrease
🔹 Highlight trends directly inside table visuals

🛠️ How to Add Up/Down Arrows

1️⃣ Create a KPI Measure with Arrow Logic

Example: Show 🔼 if sales increased, 🔽 if decreased

Dax

Sales Trend Icon = 
VAR Change = [Current Sales] - [Previous Sales]
RETURN 
SWITCH(TRUE(),
    Change > 0, "🔼",
    Change < 0, "🔽",
    "⏺️"
)

You can also use Unicode characters or emojis for arrows.

2️⃣ Concatenate Arrows with Values (Optional)

Dax

Sales with Trend = 
[Current Sales] & " " & [Sales Trend Icon]

📌 Use this in table or matrix visual for clean results.

📊 Pro Tip: Use Conditional Formatting

If using arrow images, apply conditional formatting using measures to switch between green/red icons.

Comments

Post a Comment