Forum Discussion

AvPowerBI's avatar
AvPowerBI
Icon for Post Patron rankPost 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...
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

AvPowerBI's avatar
AvPowerBI
Icon for Post Patron rankPost 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
Icon for Community Support rankCommunity 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