0

No products in the cart.

0

No products in the cart.

Home
Blog Standard
KPI
Power BI KPI Card part-1
What is KPI?
  • A KPI (Key Performance Indicator) is a visual that displays the progress of a specific measure against a defined target.
  • It provides a quick and easy way to see whether key metrics are on track, improving, or declining, which helps businesses monitor performance effectively.
    • Use cases
  • Sales Performance: Comparing actual sales against targets.
  • Customer Satisfaction: Measuring satisfaction scores against goals.
  • Project Management: Tracking project milestones or budget utilization.

    • Key Features of a KPI

    The primary value or measure you’re tracking (e.g., sales revenue, profit margin).

    The benchmark or goal against which the indicator is compared (e.g., budgeted revenue, sales target).

    A visual cue (often a color like red, yellow, or green) that shows how the indicator compares to the target.

    Green: On track or above target.
    Yellow: Nearing target but may need attention.
    Red: Below target, signaling a problem.

    STEP 1: CREATE MEASURES

    Create a total sales measure, Sales = Sum(Data[Sales])
    Sales = SUM(Data[Sales])
    Create a total target measure
    Target = SUM((Data[Target]))
    Create a measure to calculate Target%
    Target% = DIVIDE([Sales] - [Target], [Target],0)
    To display the target achieved label in appropriate color Red or Green
    Target Color = IF([Sales]>[Target], "green", "red")
    Arrow up & down
    _Arrow down = UNICHAR(9660)
_Arrow up = UNICHAR(9650)
    Format in Millions
    _Format = "$#0,,.00M;-$#0,,.00M"

    STEP 2: Create measures to hold dynamic labels

    Create a Target Achieved measure
    VAR _Value = FORMAT([Target], [_Format])
VAR _ValueChange = FORMAT([Target%], "#%")
VAR _FormattedText =
_Value &
IF([Target%] <=0,
" | " & [_Arrow down] & _ValueChange ,
" | " & [_Arrow up] & "+" & _ValueChange )
VAR _Result=
IF ( OR(ISBLANK([Target%]), [Target%]=0) , _Value, if( [Target%]=0, BLANK(), _FormattedText ) )
RETURN _Result
    en_USEnglish
    en_USEnglish