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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TylerVono
Helper III
Helper III

Pareto Calculation

Hello, Looking for ideas. Here is what I have in trying to make: a simple Paredo:

 

I have two columns:

TylerVono_0-1678325264229.png

 

Multiple Categories showing reason why purchase order was recorded as past due.

TylerVono_1-1678325285586.png

And completely unique Purchase Order Numbers

TylerVono_2-1678325306077.png

I need show the major categories culprit recorded as past due but my formula keeps wanting sum the actual purchase order numbers. I basically need a true record count of each invididual PO as an occurence, then need to figure out Cumulative Total in decending order, the Total PO count, and then Cumulative Share %. Any ideas on this workaround?

TylerVono_3-1678326399549.png

 

 

5 REPLIES 5
Len_Barr
Resolver I
Resolver I

You'll have to change the data type of the "Number" column from whole number to text. Then, in the table itself, select the Number column again and make sure it counts (distinct), not summarises it. This will give you the number of times the "number" appears. 

DOntSum.png

 

Can't help you with the rest as I don't quite understand, sorry, but here is the link to someone teaching about Pareto in PowerBI How To Make A Pareto Chart In Power BI | Step-By-S... - Microsoft Power BI Community

 

If this answer helped, chuck us an "Accepted Solution"

Thank you Len and Ashish, basically my next couple steps are as follows: RANK order them which keeps giving me '1'. Step 3: create a measure which displays the cumulative/running values.  Step 4: Make Running Total measure from the table and convert it into a dual axis/line and clustered column chart. Drag the % down.

TylerVono_0-1678334875378.png

I am basically going off this guide for Pareto: https://www.voksedigital.com/pareto-chart-in-power-bi/

 

Hi,

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Link to Dashboard/Pareto Attempt 

 

Hi Ashish, Please let me know if you can access this.

Ashish_Mathur
Super User
Super User

Hi,

Write this measure and drag it to the visual

Count = counta(Data[Number])

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors