Forum Discussion

TylerVono's avatar
TylerVono
Icon for Helper III rankHelper III
3 years ago

Paredo Chart - Cumulative Total

Hello,   I need help making a Paredo Table then chart, a cumulative total measure then Total measure I was following this guide but I am stuck: https://powerbi.tips/2016/10/pareto-charting/   Her...
Need Help
Tips and Tricks
TylerVono's avatar
TylerVono
Icon for Helper III rankHelper III
3 years ago
 
 Hello Jihwan,
 
So I am having trouble with my Pareto chart. I basically just want my CumulativeMeasure to be Descending and my Cumulative Percentage to be Ascending.
 
Cumulative Percent = DIVIDE([CumulativeMeasure],calculate([Total Count]))
 
CumulativeMeasure = CALCULATE(COUNTROWS ('Table' ), WINDOW (1,ABS,0,REL,ALL('Table'[Category]),ORDERBY(CALCULATE(COUNTROWS('Table')))))
*I deleted the DESC variable to see if that helped.
 
Total Count = CALCULATE(COUNT('Table'[Number]) ,ALLSELECTED( 'Table' ))
 
Basically if the Bar Chart is good here, but I need the line chart to ascend up.
 
Any Ideas on how to flip this line?
 

Need the line like this:

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share the download link of the PBI file.  Show the expected result in a simple Table format.  Once we get the correct numbers, we can always switch to our desired visual.