Dynamic Pareto Analysis in Power BI - Native Visuals

Guided Pareto Tutorial with PBIX file
Did you like this video? let me know, I might make more like this if there's a good response from the community
::::::::::: Links :::::::::::::::
🔥 PBIX here➡️: github.com/Pow...
🔥 Gustaw's Original Post: / urn:li:activity:720744...
::::::::::::::::::::::::::::::::::
Come find me on Linkedin: / injae-park
Thanks for taking the time to watch this video.
#PowerBI #DataAnalytics #BusinessIntelligence #powerquery

[@meedow2319]

This is the BEST Pareto Analysis in PBI I can find! Wonderfully done! Bravo!!

[@joshiguet1728]

By far the best Pareto Analyze I know. Thank you very much for sharing this information by a long video where you went in detail. Thank You very much

[@andresramirezortega6218]

I love this! I was looking for a Pareto analysis like this! This example is so well explained and super appealing from my perspective! Super nice!

[@PowerBIPark]

Awesome, thanks for the feedback! Its something different I tried out, and I'm glad it resonated

[@MarcDominicCoching]

Thanks for making this video!

[@gurvindersingharora5301]

Hello Sir, Will you please upload and teach DAX related videos on your channel ? Your style of explaining is good !

[@ricardocontreras]

Thank you!... you are very kind showing the "magic" on this sort of nice dashboard. I really appreciate it!

[@PowerBIPark]

Happy to see you find value in it. Hopefully it'll be useful to you :)

[@jamesarthur2360]

I love this video, very detailed. The length of the video is worth it as Injae Park takes time to explain the nitty-gritty of the steps😇

[@PowerBIPark]

Thanks James :)

[@CHQAQC]

Thanks for a superb video. An issue I had in past using rank for pareto is when you have equal revenue for, in this example, customers. The ranking double count and the cumulative % is impacted. I remember I needed a work around to solve that issue.

[@PowerBIPark]

Oh for sure. Rank with dense or skip doesn't really resolve it, so if you have the same values you need a workaround. Nice callout!

[@abdelraoufyessoufou3190]

excellent demonstration as always. Your impact on Social Media is out of this world. Thank you very much

[@PowerBIPark]

I appreciate that! If I don't see you on linkedin after a video I'll start to worry xD

[@abdelraoufyessoufou3190]

@@PowerBIPark 😊 This is why i keep checking your posts daily. Thank u

[@businessinsights_AlexRobe]

Awesome work! Thanks for taking uns deep down into the rabbit hole and explainig your solutions in such a detailed manner! 👍

[@PowerBIPark]

Great, I hope you learned something new from this :)

[@luisfernandomacedo1451]

You deserve 100k followers! What you taught today was really 👌

[@PowerBIPark]

Awesome. Appreciate you saying so :)

[@amaniezzat2942]

Excellent! Following you on LinkedIn and was waiting for this video :)

[@PowerBIPark]

Hope you enjoy it!

[@cathrerinezetadrones3169]

Thanks for showing things my company can actually use!

[@PowerBIPark]

Glad it's helpful!

[@ChocoHammer]

When I was doing my first Pareto in Power BI, it surprised me how easy it was :D, but now I'm working on a Pareto graph on currency data with both positive and negative numbers :D. That's not easy anymore :D

[@PowerBIPark]

ah yes, but Pareto with negative doesn't always work - waterfall might be better :)

[@rameshkunda6775]

Could you please do the Data Analysis on Real Estate Project.

[@tinaflemons263]

Thank you. I'm definitely going to try this.

[@PowerBIPark]

Nice!

[@mogarrett3045]

excellent.....love Pareto 80/20 rule, used it before

[@PowerBIPark]

for sure! it's a shame it's not out of the box in power bi, but this will do the trick :)

[@benfianso2623]

Thank you so much! Amazing work

[@ali.jawwad]

It is really helpful. Thank you and keep it up.

[@PowerBIPark]

Glad it was helpful!

[@clipe84]

Legend! I am already following you on LinkedIn! thank you so much for your video!

[@PowerBIPark]

Nice one. Hopefully this and the other videos help you out :)

[@arbazahmad7177]

Excellent...🎉 thanks for sharing

[@PowerBIPark]

Hope its useful to you :)

[@winstonsnyder6112]

Thanks Injae When I add _1 Cumulative Revenue % to the Line y-axis I get a horizontal line at 100% even though the table shows PowerDial Connect at 16%, etc,,, Why might all values show as 100% on the Line and Clustered Column Chart?

[@mariaclara8871]

Amazing!! Thank you!!

[@In_a_state]

Very good implementation.

[@PowerBIPark]

Many thanks

[@garyrowe58]

Hi, I don't understand how you chose the cut-off point ... if I have chosen 60% as my pareto value, and my second ranked row is 58% and the next is 64%, then it chooses 58% as having the lesser of the absolute difference values (2 instead of 4), but I wanted it to calculate how many rows were need to reach/exceed 60 (so needed the row with cumulative of 64%). -How can I make this happen?- "difference", if([Cumulative %age] - TargetPercentage < 0, 999, [Cumulative %age] - TargetPercentage)

[@PowerBIPark]

Hi Gary, this is definitely something I did consider. I think it's in one of the measures 4_, where gives the pareto rank. I'll see if I can take a look later :)

[@lixiasong3459]

thank you so much for the awesome YT, could you please make other YT about hiding items within one slicer if the same item is selected in another slice? mentioned by Gustaw on the Linkedin recently? please🙏

[@PowerBIPark]

Doesn't he have the code in his post? :)

[@ZainDar-t5r]

How did you get the paretovalue, the slicer you move around, precentage.

[@PowerBIPark]

It's the numeric range parameter, paretovalue = selectedvalue(parameter)

[@SumanKoirala-x6t]

a small confusion as I was going through this, what do we do if we have multiple customers where the revenue generated is same? maybe like 3 customers with revenue of 1m USD each

[@PowerBIPark]

A good way is to use window functions to resolve it :)

[@mrbartuss1]

Could you also please share the dataset?

[@PowerBIPark]

Hey Bartek, so you can just grab the data from the pbi file, just go to the table in the data view and right click on it and just copy the table. As you can see in the video, it's really just 2 columns of 19 rows:)

[@mrbartuss1]

@@PowerBIPark Oh, totally makes sense. Thank you!

[@ShoOnlineAcademy]

Is that SQL you use?

[@PowerBIPark]

only DAX in this video

[@ShoOnlineAcademy]

@@PowerBIPark Thank you. What kind of ERP system did you pull the data from? if we are using Microsoft D365, can we build KPI dashboard in D365?

[@PowerBIPark]

This is mock data, but you could for sure connect d365 data (I'm assuming dynamics) to power bi to do this

[@ShoOnlineAcademy]

@@PowerBIPark yes Dynsmics. Both Power BI and Dynamics are Microsoft products. I was told thst tgey couldn't build tge dashboard in Dynamics. Ihow can we buikd dashboard inside dynamics?

[@PowerBIPark]

Maybe this will help community.dynamics.com/blogs/post/?postid=3d6f32cf-71e4-48f9-b1cf-193e7a4c5cd2#:~:text=To%20add%20Power%20BI%20visualizations,Allow%20Power%20BI%20visualization%20embedding.