Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Krishna Nandan]

Hi All,
I want some help in creating pareto chart. I tried a lot but not able to get correctly.
Attaching the file.

——————————
Krishna Nandan
SME
Bangalore
——————————

[Steve James]

Take a look at SQLBI’s excellent article on the ABC/Pareto pattern:

https://www.daxpatterns.com/abc-classification/

——————————
Steve James
Director
——————————
——————————————-

[John Thomas]

Hi Krishna,

Here’s one on Control Charts:  (Video, Blog post, and Sample file)

Six Sigma Control Charts in Power BI – Excelerator BI

https://youtu.be/ONbIwJi2GH8

Hope this helps…

——————————
John Thomas
Huntersville NC
——————————
——————————————-

[Krishna Nandan]

Hello John,
Thank you very much for your reply. Surely i will learn something new from this and will get insight. However do you have any solution for getting pareto chart which i asked?

——————————
Krishna Nandan
SME
Bangalore
——————————
——————————————-

[John Thomas]

Krishna,

Here’s an example of Pareto Charting from Power BI Tips site..

https://powerbi.tips/2016/10/pareto-charting/

Hope this helps.

——————————
John Thomas
Huntersville NC
——————————
——————————————-

[John Thomas]

Afternoon Krishna – I ran across this today while looking for something else and thought of you.  It’s a video from Curbal, a YouTube channel I subscribe to…

DAX Fridays! #24: Running/ Cumulative totals (w Pareto chart)

——————————
John Thomas
Huntersville NC
——————————
——————————————-

[Krishna Nandan]

Thank you John,
i have seen all these videos. I will post my file as well. The problem is, i am not able to get the rank and the line graph is not accurate.
I am able to calculate running total and percentage also but the issue is above thing.

I have post another question. If possible please provide some help. Monthly comparison between fixed month and change month

——————————
Krishna Nandan
SME
Bangalore
——————————
——————————————-

[John Thomas]

Ok – post your file and I’ll give it a shot.

——————————————-