How to give up down arrow for Measure in Power Bi comparing values

[Anonymous]

How to give up down arrow for Measure in Power Bi comparing values?

I have YTD and Previous Year YTD , I need to create a KPI visual which shows YTD and Previous year YTD also comapares them , based on comparison it will show up and  down arrow.

[Anonymous · Accepted solution]

Hi @Anonymous ,

I think you will add [YTD] in Indicator Field, add [Month] in "Trend axis" and [Previous Year YTD] in Target goals in KPI visual. As far as I know, KPI visual will show Red if [YTD]< [Previous Year YTD] and show green if [YTD]> [Previous Year YTD]. We couldn't add icons like arrow to show comparison result in KPI. Here I suggest you to create a card visual, set the background of card visual as None and Group two visuals.

Measure:

Arrow =
IF (
    [YTD] = [Previous Year YTD],
    "",
    IF ( [YTD] < [Previous Year YTD], UNICHAR ( 11015 ), UNICHAR ( 11014 ) )
)

Arrow color = 
IF([YTD]<[Previous Year YTD],"Red","Green")

Select [Arrow color] measure in Card Data label Color (fx) > Format Style - Field value.

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mh2587]

Measure =
IF ( yourmeasure < 600, UNICHAR ( 9650 ), UNICHAR ( 128315 ) )
//Set your desired criteria instead of 600