Forum Discussion

AvPowerBI's avatar
AvPowerBI
Post Patron
4 years ago
Solved

Which Visual to use if Increase or Decrease

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

 

 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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

3 Replies

  • mh2587's avatar
    mh2587
    Super User
    4 years ago

    Use KPI Card this will give you the expected result

    • AvPowerBI's avatar
      AvPowerBI
      Post Patron
      4 years ago

      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's avatar
        v-easonf-msft
        Community Support
        4 years ago

        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