Forum Discussion

AdaVFR's avatar
AdaVFR
Regular Visitor
3 years ago
Solved

KPI Card with Icons

Hi everyone, 
relatively new to Power BI, so dont know all the details.

Please , let me know how i can achieve this result:
I need the arrow instead of exclamation mark to point up if above the 0, down if below the zero, on top of that, my decimals are not being rounded up toone point, although in the column properties i set it to one on both of the measures. 
First figure shall show 1.32% arrow up vs LY: 127.6

 

Please guide me how i can plug in the icons and format these two numbers. Thank you.

2 Replies

  • olgad's avatar
    olgad
    Icon for Resident Rockstar rankResident Rockstar

    Hi there, 
    here you can copy all the different icons https://unicode-table.com/en/sets/arrow-symbols/ 

    Formatting you can do in DAX

    KPI= Format([Measure1] , "0.0%")&" " &If([Measure 1]>0,"▲", "▼")& " vs LY: "&Format([Measure2], "0.0")

    Hope that works for you.
  • AdaVFR's avatar
    AdaVFR
    Regular Visitor

    Thank you for your quick response,

    all tip top.