Worst Performing KPI

[jk_adelaide]

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

[VahidDM]

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]

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 Event	First received	Unit2	Directorate	Location	Type of feedback	Month	Year	Year_Month
12-Feb-21	12-Feb-21	Unit2	Hosp-2	Unit2-ICU	Compliment	2	2021	20212
10-Nov-21	01-Dec-21	Unit2	Hosp-2	Unit2-ICU	Complaint	12	2021	202112
12-Feb-21	12-Feb-21	Unit2	Hosp-2	Unit2-ICU	Compliment	2	2021	20212
02-Sep-21	09-Sep-21	Unit2	Hosp-2	Unit2-ICU	Compliment	9	2021	20219
11-Feb-21	11-Feb-21	Unit2	Hosp-2	Unit2-ICU	Compliment	2	2021	20212
11-Feb-21	11-Feb-21	Unit2	Hosp-2	Unit2-ICU	Compliment	2	2021	20212
13-Apr-21	13-Apr-21	Unit2	Hosp-2	Unit2-OP	Complaint	4	2021	20214
08-Dec-20	18-Jan-21	Unit2	Hosp-2	Unit2-OP	Complaint	1	2021	20211
04-Jan-21	04-Jan-21	Unit2	Hosp-2	Unit2-OP	Complaint	1	2021	20211
02-Mar-21	19-Jul-21	Unit21	Hosp-1	Unit1-OP	Complaint	7	2021	20217
28-Jul-21	28-Jul-21	Unit21	Hosp-1	Unit1-OP	Compliment	7	2021	20217
08-Jul-21	09-Jul-21	Unit21	Hosp-1	Unit1-OP	Compliment	7	2021	20217
13-Jul-21	13-Jul-21	Unit21	Hosp-1	Unit1-OP	Compliment	7	2021	20217
20-Jul-21	26-Jul-21	Unit21	Hosp-1	Unit1-OP	Complaint	7	2021	20217
05-Jul-21	09-Jul-21	Unit21	Hosp-1	Unit1-OP	Compliment	7	2021	20217
28-Jun-21	09-Jul-21	Unit21	Hosp-1	Unit1-OP	Compliment	7	2021	20217
26-Jul-21	26-Jul-21	Unit21	Hosp-1	Unit1-OP	Compliment	7	2021	20217
05-Jul-21	09-Jul-21	Unit21	Hosp-1	Unit1-OP	Compliment	7	2021	20217
11-Feb-21	19-Feb-21	Unit21	Hosp-1	Unit1-OP	Complaint	2	2021	20212
28-Jun-21	09-Jul-21	Unit21	Hosp-1	Unit1-OP	Compliment	7	2021	20217
28-Jun-21	09-Jul-21	Unit21	Hosp-1	Unit1-OP	Compliment	7	2021	20217
28-Jun-21	09-Jul-21	Unit21	Hosp-1	Unit1-OP	Compliment	7	2021	20217

KPI-2 Data

Actual ABC	Level 3	Level 2	Directorate	Incident/Event date	Location	ABC	Level 1	Year	Month	YearMonth
ABC 4	Wrong strength - Administration of medication	Admin Med	Hosp-1	11-Feb-21	Unit1-ICU	ABC4	Medication	2021	2	20212
ABC 4	Wrong medication - Administration of medication	Admin Med	Hosp-1	25-Sep-21	Unit1-ICU	ABC4	Medication	2021	9	20219
ABC 4	Wrong frequency / rate - Administration of medication	Admin Med	Hosp-1	19-May-21	Unit1-ICU	ABC4	Medication	2021	5	20215
ABC 4	Wrong dose - Administration of medication	Admin Med	Hosp-1	21-May-21	Unit1-OP	ABC4	Medication	2021	5	20215
ABC 4	Wrong dose - Administration of medication	Admin Med	Hosp-2	01-Feb-21	Unit2-ICU	ABC4	Medication	2021	2	20212
ABC 4	Wrong route - Administration of medication	Admin Med	Hosp-1	13-Mar-21	Unit1-ICU	ABC4	Medication	2021	3	20213
ABC 4	Wrong route - Administration of medication	Admin Med	Hosp-1	27-Oct-21	Unit1-ICU	ABC4	Medication	2021	10	202110
ABC 4	Wrong route - Administration of medication	Admin Med	Hosp-1	02-Apr-21	Unit1-ICU	ABC4	Medication	2021	4	20214
ABC 4	Wrong formulation - Administration of medication	Admin Med	Hosp-1	24-Oct-21	Unit1-ICU	ABC4	Medication	2021	10	202110
ABC 4	Documentation of administration absent or incorrect	Admin Med	Hosp-1	24-Mar-21	Unit1-OP	ABC4	Medication	2021	3	20213

[v-chenwuz-msft]

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.

[jk_adelaide]

Hi Chenwu zhu,

Thanks for the help. I have 20 KPI's calculated from different data sources and not from one table. The problem is how can put all these KPI values into one table and show the worst 5.

I do have all the KPI values as measures and when filtering by Year, Month and Location it should change the Worst KPI's as well. Everything working fine till measures but struck to show this by comparing and finding the worst or top KPI's in one page. Hope you understand the issue. Any idea or suggestion.

Thanks,

JK