Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jk_adelaide
Frequent Visitor

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

4 REPLIES 4
VahidDM
Super User
Super User

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/

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

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.

vchenwuzmsft_0-1649320288910.png

 

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.

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors