Forum Discussion
How to modify pareto chart
I want my pareto to be like this
but my chart is like this
can anyone help me please
2 Replies
Change your secondary Y axis to start at 0.
Try these steps:
Ranking - RANKX(ALLSELECTED(Column), [Count])Cumulative Count = CALCULATE([Count], TOPN([Ranking], All(Column]), [Count]))Cumulative % = DIVIDE([Cumulative Count], CALCULATE([Count], ALL(Column])))
