cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Zaky Member
Member

Need Help - Pivot table

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?

 

PriorityMetMissedTotal TicketPerformance Achievement
S211011100%
S32820282100%
S49462116859630698.25%
SVIP17851696179699.39%
2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Need Help - Pivot table

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.

View solution in original post

Vishnu_1980 Frequent Visitor
Frequent Visitor

Re: Need Help - Pivot table

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.Img1.PNG

 

Please find below the code as he given:

 

Met = CALCULATE(COUNTROWS(New),New[MeasurementStatus]="Met")
Missed = CALCULATE(COUNTROWS(New),New[MeasurementStatus]="Missed")
Total = 'New'[Met]+'New'[Missed]
Performance percentage = 'New'[Met]/'New'[Total]
 
Once we created kindly use matrix tableImg12.PNG
 
Thanks

View solution in original post

14 REPLIES 14
Super User
Super User

Re: Need Help - Pivot table

Hi @Zaky

You can use the matrix visual. It works pretty much like a pivot table

Zaky Member
Member

Re: Need Help - Pivot table

Hi AIB,

 

I did used matrix visual, but the question is how to get percentage for each Priority rows.

Super User
Super User

Re: Need Help - Pivot table

@Zaky

 

Place [Priority] in the rows of the matrix and [Performance Achievement] on values of the matrix?

Vishnu_1980 Frequent Visitor
Frequent Visitor

Re: Need Help - Pivot table

Hi 

 

PLease find the screen of the table and confirm it satisfies your requirementmatrix.PNG

 

If this not your requirement, kindly share some sample output

 

Community Support Team
Community Support Team

Re: Need Help - Pivot table

@Zaky,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Zaky Member
Member

Re: Need Help - Pivot table

Hi Vishnu,

 

Yes, I want to get the percentage performance of the ticket total.

 

 

Thanks

Zaky Member
Member

Re: Need Help - Pivot table

Hi Vishu,

 

Could you please show me how to do it?

Vishnu_1980 Frequent Visitor
Frequent Visitor

Re: Need Help - Pivot table

Hi,

 

Sorry for the Img1.PNGImg2.PNGdelay in response.Please find below the screen and let me its working or not ? Thanks

Zaky Member
Member

Re: Need Help - Pivot table

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 IDSummaryStatusSeverityCustomer Full NameMeasurementStatusClosed Date
ICT_INC00000203Installing softwareClosedS4M Azim B Omar (BFC&P-TRM/PET-ICT)Met16/02/2017 8:50
ICT_INC00000026Report an Issue - Other ICT IssueClosedS4M Fadhil B Hassan Basri (PMO/Upstream)Met15/02/2017 11:50
ICT_INC00006521Report an Issue - ApplicationClosedS4M Azhari Jahin (PTEC/EPEMSB)Met21/02/2017 16:08
ICT_INC00000236user unable to login to wireless reimagineClosedS4Nurul Hazwani Bt Ahmad Shokri (TES/PCFSSB)Met15/02/2017 9:50
ICT_INC00001175Windows: Unable to login to computer due to domain issueClosedS4Maziatul Akma Fadzlina M Fadzil (FINANCE/PCGB)Met08/02/2017 10:16
ICT_INC00000570Hardware - Screen issue (Laptop)ClosedS4Trijono Hadi Wibowo (PMO/Upstream)Missed15/02/2017 12:50
ICT_INC00001186Bitlocker-To-Go: Password failure (Unable to unlock)ClosedS4Irwan B M Faizal Din Chan (PMO/Upstream)Missed15/02/2017 10:50
ICT_INC00001194Hardware - Docking Station related issuesClosedSVIPZahariah Bt A Rahman (GSC/PETH)Missed16/02/2017 9:51
ICT_INC00000572Network : Unable to connect to LANClosedS4W Nor Ezah Bt W A Rahman (FS2/PETH)Met15/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.

 

SeverityMetMissedTotal Ticket
S4628
SVIP 11
Grand Total639

 

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 136 members 1,449 guests
Please welcome our newest community members: