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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Trying to make a Pareto chart

Hello!

 

I am trying to make a Pareto chart in PowerBI for some ticket analysis however I am having some difficulties. Ive watched a couple youtube videos however they dont seem to apply well to the datasets I have so Im hoping I could have some assistance.

 

I have a table with 3 Columns, Ticket #, Ticket Category, ResolutionCode and im trying to do the pareto analysis with the ticket category.

 

Any recomendations would be greatly appreciated! 

1 ACCEPTED SOLUTION

Hi @Anonymous,

 

Attached please find a sample pbix, that I believe will get you what you are looking for:

Steps:

- Create a summary table for your pareto analysis

- include counts and deterministic ranking column

- create a cummulative % measure, that divides the rolling sum by the total count of tickets.

 

Calc table, columns and measures all included in the pbix.

results in 

richbenmintz_0-1627408564468.png

 

hope this heps you out



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


View solution in original post

4 REPLIES 4
richbenmintz
Solution Sage
Solution Sage

Hi @Anonymous,

 

Are you able to provide some sample data?

 

Thanks,



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


amitchandak
Super User
Super User

@Anonymous , Assuming you are using count ot #ticket and axis is ticket category

 

then a measure as a line in clustered line visual 

 

measure = calculate(count(Table[#ticket]), filter(allselected(Table), [ticket category] = max([ticket category])) )

Anonymous
Not applicable

Hi!

 

Thank you for this, I was able to add the measure as a line however do you know if it is possible to show the percentages on the line for the Pareto Analysis?

KarlS17_0-1627405519479.png

 



Hi @Anonymous,

 

Attached please find a sample pbix, that I believe will get you what you are looking for:

Steps:

- Create a summary table for your pareto analysis

- include counts and deterministic ranking column

- create a cummulative % measure, that divides the rolling sum by the total count of tickets.

 

Calc table, columns and measures all included in the pbix.

results in 

richbenmintz_0-1627408564468.png

 

hope this heps you out



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.