Forum Discussion
Pareto Calculation
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.
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.
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.
