Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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 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 |
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.
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
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |