Forum Discussion
Up and down Arrows
- 5 years ago
Hi Anonymous
You can do this with Custom String Formatting to give you the arrows
https://www.myonlinetraininghub.com/custom-formatting-strings-in-power-bi
Select your measure and in the Format string area type (or copy/paste this) "▲";"▼"; which will display ▲ for positive values and ▼ for negative values
The code for ▲ is ALT+30 and ▼ is ALT+31
Arrow Symbols: Left, Right, Up and Down Arrow (alt-codes.net)
Regards
Phil
Hi Anonymous
Here's an example file you can download
which is based on this tutorial
Key Performance Indicator (KPI) visuals - Power BI | Microsoft Docs
You'll see that the Indicator measure in the KPI is formatted using a custom string to indicate if this year's peformance is better or worse than last year's
"▼ $"#0,000;"▲ $"#0,000;
Note that in this instance a positive value is worse.
Regards
Phil