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
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.
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
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
Why am i getting those wrong arrow symbols here.
Please Suggest me.
Mohan V
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
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.
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
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
Why am i getting those wrong arrow symbols here.
Please Suggest me.
Mohan V