topic Re: KPI Card with Icons in DAX Commands and Tips

KPI Card with Icons

AdaVFR — Tue, 31 Jan 2023 08:55:10 GMT

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.

Re: KPI Card with Icons

olgad — Tue, 31 Jan 2023 08:56:28 GMT

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.

Re: KPI Card with Icons

AdaVFR — Tue, 31 Jan 2023 08:58:12 GMT

Thank you for your quick response,

all tip top.