Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm new in Power BI. My question is how to create Pivot table (like excel) dashboard in Power BI? I want to get performance achievement percentage for each priority rows as per table below. Could you please help with steps?
Priority | Met | Missed | Total Ticket | Performance Achievement |
S2 | 11 | 0 | 11 | 100% |
S3 | 282 | 0 | 282 | 100% |
S4 | 94621 | 1685 | 96306 | 98.25% |
SVIP | 1785 | 1696 | 1796 | 99.39% |
Solved! Go to Solution.
Hi,
Try these measures:
Met = CALCULATE(COUNTROWS(Table1),Table1[MeasurementStatus]="Met")
Missed = CALCULATE(COUNTROWS(Table1),Table1[MeasurementStatus]="Missed")
Total = [Met]+[Missed]
Performance (%) = [Met]/[Missed]
Hope this helps.
Hi ,
Please find the attached screen shot.Kindly have a look and confirm me if anything required.IF performance percentage needs to calcualte, we need create few measure.New is the table name
With the help of ashish mathur code i ahve created four measure.
Please find below the code as he given:
You may refer to the following post to add a measure.
https://community.powerbi.com/t5/Desktop/Dynamic-Difference-Measure-Using-Slicer/m-p/590745#M280280
Hi AIB,
I did used matrix visual, but the question is how to get percentage for each Priority rows.
Place [Priority] in the rows of the matrix and [Performance Achievement] on values of the matrix?
Hi
PLease find the screen of the table and confirm it satisfies your requirement
If this not your requirement, kindly share some sample output
Hi Vishu,
Could you please show me how to do it?
Hi,
Sorry for the delay in response.Please find below the screen and let me its working or not ? Thanks
Hi Vishnu,
Let says i have the data as per below.
My point is to have Performance Achievement for total of Met/Missed*100. So you will get the percentage.
Incident ID | Summary | Status | Severity | Customer Full Name | MeasurementStatus | Closed Date |
ICT_INC00000203 | Installing software | Closed | S4 | M Azim B Omar (BFC&P-TRM/PET-ICT) | Met | 16/02/2017 8:50 |
ICT_INC00000026 | Report an Issue - Other ICT Issue | Closed | S4 | M Fadhil B Hassan Basri (PMO/Upstream) | Met | 15/02/2017 11:50 |
ICT_INC00006521 | Report an Issue - Application | Closed | S4 | M Azhari Jahin (PTEC/EPEMSB) | Met | 21/02/2017 16:08 |
ICT_INC00000236 | user unable to login to wireless reimagine | Closed | S4 | Nurul Hazwani Bt Ahmad Shokri (TES/PCFSSB) | Met | 15/02/2017 9:50 |
ICT_INC00001175 | Windows: Unable to login to computer due to domain issue | Closed | S4 | Maziatul Akma Fadzlina M Fadzil (FINANCE/PCGB) | Met | 08/02/2017 10:16 |
ICT_INC00000570 | Hardware - Screen issue (Laptop) | Closed | S4 | Trijono Hadi Wibowo (PMO/Upstream) | Missed | 15/02/2017 12:50 |
ICT_INC00001186 | Bitlocker-To-Go: Password failure (Unable to unlock) | Closed | S4 | Irwan B M Faizal Din Chan (PMO/Upstream) | Missed | 15/02/2017 10:50 |
ICT_INC00001194 | Hardware - Docking Station related issues | Closed | SVIP | Zahariah Bt A Rahman (GSC/PETH) | Missed | 16/02/2017 9:51 |
ICT_INC00000572 | Network : Unable to connect to LAN | Closed | S4 | W Nor Ezah Bt W A Rahman (FS2/PETH) | Met | 15/02/2017 17:50 |
The result supposed to be like below table which is i pivot in excel. I want in Power BI to visualize the Performance percentage right after Total Ticket column.
Severity | Met | Missed | Total Ticket |
S4 | 6 | 2 | 8 |
SVIP | 1 | 1 | |
Grand Total | 6 | 3 | 9 |
Hi,
Try these measures:
Met = CALCULATE(COUNTROWS(Table1),Table1[MeasurementStatus]="Met")
Missed = CALCULATE(COUNTROWS(Table1),Table1[MeasurementStatus]="Missed")
Total = [Met]+[Missed]
Performance (%) = [Met]/[Missed]
Hope this helps.
Hi,
Could you please show steps to do this?
Thanks.
Hi ,
Please find the attached screen shot.Kindly have a look and confirm me if anything required.IF performance percentage needs to calcualte, we need create few measure.New is the table name
With the help of ashish mathur code i ahve created four measure.
Please find below the code as he given:
one more thing..how can i make the % symbol available after the percentage number? mine not shown
Hi,
Thanks it works perfectly !
Hi Vishnu,
Yes, I want to get the percentage performance of the ticket total.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |