Need help building a special "Pareto" Graph

[Anonymous]

Hi!

I am hoping someone can assist me in buliding a similar graph like the one attached. The graph shows the sales development compared to the cumulative sales (illustrated by the line). This graph was built in Excel but I want to build it in Power BI too. What visual would be best suited for this? Is it possible to show that product x accounts for y % of the sales?

Hoping for help and best regards,

[amitchandak · Accepted solution]

@Anonymous , You can create a running total or cumulative using quick measure on the axis column and use clustered line visual(switch off secondary axis)

or create a measure like

calculate([sales], filter(allselected(Date), Date[Date] <=Max(Date[Date])))

You can try some custom visual

https://appsource.microsoft.com/en-us/marketplace/apps?search=Pareto%20&page=1&product=power-platform%3Bpower-bi-visuals

[Anonymous]

Hello sir Amit, 

Thank you so much, this resolved the issue. Thank you!

PBIGuy1234