cancel
Showing results for
Did you mean:
Highlighted
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?

 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%
2 ACCEPTED SOLUTIONS

Accepted Solutions
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.

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.

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 table

Thanks
14 REPLIES 14
Super User

## Re: Need Help - Pivot table

Hi @Zaky

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

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

## Re: Need Help - Pivot table

@Zaky

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

Frequent Visitor

## Re: Need Help - Pivot table

Hi

PLease find the screen of the table and confirm it satisfies your requirement

If this not your requirement, kindly share some sample output

Community Support Team

## Re: Need Help - Pivot table

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.
Member

## Re: Need Help - Pivot table

Hi Vishnu,

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

Thanks

Member

## Re: Need Help - Pivot table

Hi Vishu,

Could you please show me how to do it?

Frequent Visitor

## Re: Need Help - Pivot table

Hi,

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

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 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

Announcements

#### Challenge: Can You Solve These?

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

#### Community News & Announcements

Get your latest community news and announcements.

#### 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.

#### Win Power BI Swag with Community Kudopalooza!

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

Top Kudoed Authors
Users Online
Currently online: 136 members 1,449 guests
Recent signins: