Which Visual to use if Increase or Decrease

[AvPowerBI]

Hi,

I am after a visual like something below, which it will show a arrown down if the % value is negative and arrow showing up if the % value is positive

The DAX I have that tells be the percentage is the below

% Headcount CM v PM =

1-(DIVIDE([Headcount SPLM],[Headcount]))

Which is based on the below

Headcount =

CALCULATE(

COUNTX(

FILTER('HR','Fact'[EmpStartDate]<=MAX('Dates'[Date])

&&

(ISBLANK('Fact'[EmpEndDate])

|| 'HR'[EmpEndDate]>MAX(Dates[Date]))),

'HR'[EmpId])

) + 0

Headcount SPLM =

CALCULATE(

[Headcount]+0,

PREVIOUSMONTH(Dates[Date])

)

Thanks

[mh2587]

Use KPI Card this will give you the expected result

[AvPowerBI]

Hi @mh2587 

Thanks for your reply, I have used the KPI visualization but it does not give me a option to change the indicator icons, I want a triangle like my my picture but all it is showing is a tick icon if postive or and exclamation mark if negative

Are you aware of any other KPI visuals that I could use?

[v-easonf-msft · Accepted solution]

Hi, @AvPowerBI 

You need to create cards for arrown icon and data separately and apply custom color measure to the color of data lable.
1. create arrown icon card

image = IF([%Headcount CM v PM]<0,UNICHAR("9660"),UNICHAR("9650"))

2.create meausre 'color' and apply it to the color of card data label

color = IF([%Headcount CM v PM]<0,"red","green")

result：

Best Regards,
Community Support Team _ Eason