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: CumulativeMeasu...
Need Help
Tips and Tricks
  • 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