Up and down Arrows

[Anonymous]

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) 

Link: https://community.powerbi.com/t5/Desktop/Embedding-up-and-down-arrows-in-visual-and-changing-them-ba...

Here are my measures

CurrentLessPreviousMonth =

VAR Red = UNICHAR(9660)

VAR GREEN = UNICHAR(9650)

Return

if([CaseCount]-[PreviousMnthCases]>0,Green,Red)

and

Arrows = IF([CurrentLessPreviousMonth]>0,1,0)

i cannot get it to work...as i have text in the first measure and integer in second...

HELP..

[PhilipTreacy]

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

[PhilipTreacy · Accepted solution]

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

[tamerj1]

@PhilipTreacy 
Thank you!

[Anonymous]

Hi Phil

Do you have an example please

[PhilipTreacy]

Hi @Anonymous 

I linked to an article with lots of examples.

regards

Phil

[Tahreem24]

@Anonymous ,

Create a measure like below:

Arrow = IF(yourMeasure >0,UNICHAR(9650),UNICHAR(128315))

[Anonymous]

Hi Tahreem, How do i apply the CF rule to the Arrow measure???

[Tahreem24]

@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.

[Anonymous]

Hi Tahreem 

can you apply this to a card visual...is what i need