Forum Discussion
Making a Pareto graph readable
I'm trying to figure out what percent of my assets cause what percent of my incidents. I have 1732 assets and 5712 incidents. I've created this table, and just by brute force I can figure that 45% of my assets cause 76% of my incidents.
But the graphic created from it is hardly readable:
Having 1732 separate columns is no good! How can I consolidate this chart? Could I group every 50 columns into a single column? Am I going about this the wrong way?
4 Replies
You could create a visual showing top 25%, 50%, 75% of incidents with % of assets.
can you share some sample data or PBIX file (via a file sharing service)?
Hi, ReadTheIron ;
Try it.
percent1 = DIVIDE(SUM([IncidentsMeasure]),CALCULATE(SUM('Table'[IncidentsMeasure]),ALL('Table')))percent2 = VAR _RATE=[percent1] RETURN CALCULATE([percent1],FILTER(ALL('Table'),[percent1]>=_RATE))The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I can't write this part of the measure:
(SUM('Table'[IncidentsMeasure])IncidentsMeasure is a measure not a column in a table.
Sorry for the delay, it took me a minute to figure out how to anonymize and share my data. Here's the PBIX file; let me know if you have trouble downloading it.
