Forum Discussion
Up and down Arrows
Hi Experts
I am trying to add up and down arrows to a KPI Visual and no luck
Here is a post i found on line from the community (scroll down to the reply after community memeber)
Here are my measures
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
9 Replies
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
PhilipTreacy
Thank you!Hi Anonymous
I linked to an article with lots of examples.
regards
Phil
Anonymous ,
Create a measure like below:
Arrow = IF(yourMeasure >0,UNICHAR(9650),UNICHAR(128315))
Anonymous ,
Just take that Arrow measure in your table and go to field formatting option of the table visual then Select Arrow from drop down then set the font color to Green.
In below screen shot I did same i.e. if Status value is greate than 25 so Green else Red.
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
