Need Help to get resolve on multiple queries of Custom KPI creation

BunnyMadhu

New Member
Joined
May 13, 2017
Messages
3
Hello All,

I am trying to create kpi's like showing UP and Down arrows for different kind of data.
But facing multiple issues.
I need your help to reolve these issues.

1:- Cant Show Images of UP and Down arrows while creating KPI.
Table is
large



Measure for KPI creation is,
Measure = IF(ISBLANK([PlanSum]),"No Data Available ",[PlanSum])&" "&IF([PlanSum]=[PlanPrevMon],"",IF([PlanSum] > [PlanPrevMon],UNICHAR(8679),UNICHAR(8681))&IF([PlanSum]<=0,"",""))And this gives me perfect result(please suggest me if ay better way for this).

But when i tried to show UP and DOWN image arrows instead of unichar arrows i cant.
Measure is
Measure = IF(ISBLANK([PlanSum]),"No Data Available ",[PlanSum])&" "&IF([PlanSum]=[PlanPrevMon],"",IF([PlanSum] > [PlanPrevMon],"https://cdn3.iconfinder.com/data/icons/musthave/48/Stock%20Index%20Up.png","https://cdn3.iconfinder.com/data/icons/musthave/48/Stock%20Index%20Down.png")&IF([PlanSum]<=0,"",""))
Output is value with url.

How do i can get the Image arrow.Or else is there any other way to do this.

2:- Same queries But not working in percentage value

For Calculating the previews month values
Measure:-
Contri Prev Mon = CALCULATE([Contri%],PREVIOUSMONTH('Month Year'[Date]))But the values are changed to decimal.
large


Why am i getting the values in decimals here.
If i changed that Contri% to decimals and do the rest of queries like

Measure:-
ContriArrows = IF(ISBLANK([Contri%]),"No Data Available ",[Contri%])&" "&IF([Contri%]=[Contri Prev Mon],"",IF([Contri%] > [Contri Prev Mon],UNICHAR(8679),UNICHAR(8681))&IF([Contri%]<=0,"",""))
And the output is
large


Fine its perfect.
but same above, if i include the UP and Down arrows images URL's it gives same output as Q1.
So how can i show the values in % and with the Up and Down arrows.

And for this contri% arrows kpi i have written another calculated column,

ContriKeys1 = SWITCH(
TRUE(),
[Contri Prev Mon]=BLANK(),"",
[Contri%] <= 0,"",
[Contri%] > [Contri Prev Mon],"https://cdn3.iconfinder.com/data/icons/musthave/48/Stock%20Index%20Up.png",
[Contri%] < [Contri Prev Mon],"https://cdn3.iconfinder.com/data/icons/musthave/48/Stock%20Index%20Down.png",
[Contri%] = [Contri Prev Mon],"")

But it giving me the wrong arrow symbol
large

Why am i getting those wrong arrow symbols here.

Please Suggest me.
Mohan V
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,215,616
Messages
6,125,860
Members
449,266
Latest member
davinroach

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top