Forum Discussion

TylerVono's avatar
TylerVono
Helper III
3 years ago

Pareto Chart - Inverting the Cumulative % Line Chart - Support Needed

Hello, I am trying to get help in inverting my line chart to show a true Pareto. Does anyone know how to invert a line here? Maybe a cheat way?

 

Here are my measures:

 

Y-Axis:

CumulativeMeasure = CALCULATE(COUNTROWS ('Table' ), WINDOW (1,ABS,0,REL,ALL('Table'[Category]),ORDERBY(CALCULATE(COUNTROWS()))))
 
Line Y-Axis:
Cumulative Percent = DIVIDE([CumulativeMeasure],calculate([Total Count]))
 

Here is what I want it to look like:

 

File: 

https://www.dropbox.com/s/8n9hl1paweurr8o/Past%20Due%20Summary%20%285%29.pbix?dl=0

 

Need Help
Tips and Tricks

2 Replies

    • TylerVono's avatar
      TylerVono
      Helper III
      3 years ago

      I do not see this as a solution. Here are my entries:

       

      X-Axis: Category

      Y-Axis:

      CumulativeMeasure = CALCULATE(COUNTROWS ('Table'), WINDOW (1,ABS,0,REL,ALL('Table'[Category]),ORDERBY(CALCULATE(COUNTROWS()))))
       
      Line Y-Axis =
      Cumulative Percent = DIVIDE([CumulativeMeasure],calculate([Total Count],ALLSELECTED()))
       
      The Line Y-Axis is what I need to invert.
       
      Here is another problem... my Cumultative Total is not cumming up correctly, it is showing a total 461 less than the Cumulative Measure
       
      This is my Cumulative Total, its not summing correctly. Which makes the cumulative percent at 1.15
       
      CumulativeTotal = calculate('Table'[Count],filter(allselected('Table'),'Table'[Category]<=MAX('Table'[Category])))
       

       

      https://www.dropbox.com/s/8n9hl1paweurr8o/Past%20Due%20Summary%20%285%29.pbix?dl=0