Up\Down arrows in KPI

[Noak]

Hello,

I cant find a well explained solution to how I can add green-up\red-down arrows to my KPI Indicator.

 e.g: (In this case I need additional red down arrow)

Please assit.

BR,

NOA.

[v-huizhn-msft]

Hi @Noak,

Up to now, green-up\red-down arrows are not available in Power BI desktop, there is a request here, you can vote it. Thanks for understanding.

Best Regards,
Angelia

[Greg_Deckler]

You need to put something in your "Target goals" area of the visualization and then you will get red and green indicator. You will get an exclamation point or a checkmark.

[Noak]

hey @Greg_Deckler

My target is a condition:

If there's an increase the prcentage will be possitive e.g+4.3% then Green arrow else negative Red arrow.

is that possible to initiate this condition in the "Target goals" area of the visualization?.

[Greg_Deckler]

You shouldn't be using a KPI visualization then

[Noak]

So what do you recommend? @Greg_Deckler

[Anonymous]

@Noak Use the below measure and make it as card.

If you are comparing with previous values if it is by monthly then

Percentage% = [Measure for percentage]

KPIArrows = IF(ISBLANK([Percentage%]),"No Data Available ",[Percentage%]])&" "&IF([Percentage%]]=[PrevMonPercentage],"",IF([Percentage%]] > [PrevMonPercentage],UNICHAR(8679),UNICHAR(8681))

[Noak]

Hi @Anonymous

Thank you for your advice, unfortunately UNICHAR(8681) and UNICHAR(8679) is not recognize.

I would like to clarify:

@Greg_Deckler@Anonymous

From the start I used the card visual with dynamic period mesaure (via attached image)

code:

KPI Indicator = if(HASONEVALUE('Filters'[Period]),
SWITCH(FIRSTNONBLANK('Filters'[Period],'Filters'[Period]),
"Last 24h",[today]/[Yastedrday]-1,
"Last 7d",[this week]/[last week]-1,
"Last Month",[this month]/[last month]-1,
"Last Year",[this year]/[last year]-1),
BLANK()
)

All I want is a little green\red arrow to add to this visuale based on the condition: IF result>0 ,green,red.

very easy just dunno what feature is avalible in power bi to initiate it, please help me? 

[Greg_Deckler · Accepted solution]

What you might want to do is to have a table with URL's of up arrow and down arrow. You could then set this as an Image URL in the data model and display them in a table but filter the table such that it shows the appropriate one at the appropriate time. Something along those lines.

[sthuo]

Hi,

This should be a basic visual to provide. There are lots of complex visuals in power bi. MSFT, please act. Am looking for one urgently.

Thanks in advance.

[Noak]

@Greg_Deckler yes I read about it,

Thought maybe PBI provides quicker solution.

thank you.