Forum Discussion

jk_adelaide's avatar
jk_adelaide
Frequent Visitor
4 years ago

Worst Performing KPI

Hi,

I have 15 different KPI data sources and I want to find the worst performing 5 KPIs in a report based on the date range.  I have done an individual analysis of each KPI but I am stuck with picking the 5 worst KPIs from the 15 on a given range of dates.

Any idea?

Thanks

JK

KPI Ranking

4 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi jk_adelaide 

     

    Can you post sample data as text and expected output?
    Not enough information to go on;

    please see this post regarding How to Get Your Question Answered Quickly:
    https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

    The most important parts are:
    1. Sample data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.
    4. Relation between your tables

    Appreciate your Kudos!!
    LinkedIn:www.linkedin.com/in/vahid-dm/

    • jk_adelaide's avatar
      jk_adelaide
      Frequent Visitor
      4 years ago

      Hi Vahid,

      Thanks for the quick response appreciated it. I have added sample data for your ref. In the same way, I have more data sources and KPIs. Most of the visuals show month-wise(few in Qtr and 6month, yearly as well) and have targets as well. I want to show the worst performing KPIs on one page so can give more attention to them. The attached sample data can generate 4 different KPIs and I want to show the worst performing one on a given date range.

       

      KPI-1 Data

       

      Date of EventFirst receivedUnit2DirectorateLocationType of feedbackMonthYearYear_Month 
      12-Feb-2112-Feb-21Unit2Hosp-2Unit2-ICUCompliment2202120212 
      10-Nov-2101-Dec-21Unit2Hosp-2Unit2-ICUComplaint122021202112 
      12-Feb-2112-Feb-21Unit2Hosp-2Unit2-ICUCompliment2202120212 
      02-Sep-2109-Sep-21Unit2Hosp-2Unit2-ICUCompliment9202120219 
      11-Feb-2111-Feb-21Unit2Hosp-2Unit2-ICUCompliment2202120212 
      11-Feb-2111-Feb-21Unit2Hosp-2Unit2-ICUCompliment2202120212 
      13-Apr-2113-Apr-21Unit2Hosp-2Unit2-OPComplaint4202120214 
      08-Dec-2018-Jan-21Unit2Hosp-2Unit2-OPComplaint1202120211 
      04-Jan-2104-Jan-21Unit2Hosp-2Unit2-OPComplaint1202120211 
      02-Mar-2119-Jul-21Unit21Hosp-1Unit1-OPComplaint7202120217 
      28-Jul-2128-Jul-21Unit21Hosp-1Unit1-OPCompliment7202120217 
      08-Jul-2109-Jul-21Unit21Hosp-1Unit1-OPCompliment7202120217 
      13-Jul-2113-Jul-21Unit21Hosp-1Unit1-OPCompliment7202120217 
      20-Jul-2126-Jul-21Unit21Hosp-1Unit1-OPComplaint7202120217 
      05-Jul-2109-Jul-21Unit21Hosp-1Unit1-OPCompliment7202120217 
      28-Jun-2109-Jul-21Unit21Hosp-1Unit1-OPCompliment7202120217 
      26-Jul-2126-Jul-21Unit21Hosp-1Unit1-OPCompliment7202120217 
      05-Jul-2109-Jul-21Unit21Hosp-1Unit1-OPCompliment7202120217 
      11-Feb-2119-Feb-21Unit21Hosp-1Unit1-OPComplaint2202120212 
      28-Jun-2109-Jul-21Unit21Hosp-1Unit1-OPCompliment7202120217 
      28-Jun-2109-Jul-21Unit21Hosp-1Unit1-OPCompliment7202120217 
      28-Jun-2109-Jul-21Unit21Hosp-1Unit1-OPCompliment7202120217 

       

       

      KPI-2 Data

       

      Actual ABCLevel 3Level 2DirectorateIncident/Event dateLocationABCLevel 1YearMonthYearMonth
      ABC 4Wrong strength - Administration of medicationAdmin MedHosp-111-Feb-21Unit1-ICUABC4Medication2021220212
      ABC 4Wrong medication - Administration of medicationAdmin MedHosp-125-Sep-21Unit1-ICUABC4Medication2021920219
      ABC 4Wrong frequency / rate - Administration of medicationAdmin MedHosp-119-May-21Unit1-ICUABC4Medication2021520215
      ABC 4Wrong dose - Administration of medicationAdmin MedHosp-121-May-21Unit1-OPABC4Medication2021520215
      ABC 4Wrong dose - Administration of medicationAdmin MedHosp-201-Feb-21Unit2-ICUABC4Medication2021220212
      ABC 4Wrong route - Administration of medicationAdmin MedHosp-113-Mar-21Unit1-ICUABC4Medication2021320213
      ABC 4Wrong route - Administration of medicationAdmin MedHosp-127-Oct-21Unit1-ICUABC4Medication202110202110
      ABC 4Wrong route - Administration of medicationAdmin MedHosp-102-Apr-21Unit1-ICUABC4Medication2021420214
      ABC 4Wrong formulation - Administration of medicationAdmin MedHosp-124-Oct-21Unit1-ICUABC4Medication202110202110
      ABC 4Documentation of administration absent or incorrectAdmin MedHosp-124-Mar-21Unit1-OPABC4Medication2021320213
      • v-chenwuz-msft's avatar
        v-chenwuz-msft
        Community Support
        4 years ago

        Hi jk_adelaide ,

         

        Not really understand how your kpi is calculated.

         

        You can use the filter on this visual or page at year or month level, and filter type is Top N as the screenshot. And put your expression of [KPI] in to By value box.

         

        Best Regards

        Community Support Team _ chenwu zhu

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.