πŸ“ˆ 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

Popular Posts