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

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

@PowerBIPark

28 күн бұрын

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

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

22 күн бұрын

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

Thank you so much! Amazing work

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

26 күн бұрын

Thanks James :)

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

@PowerBIPark

23 күн бұрын

Hope you enjoy it!

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

@PowerBIPark

27 күн бұрын

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

@abdelraoufyessoufou3190

27 күн бұрын

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

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

@PowerBIPark

16 күн бұрын

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

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

22 күн бұрын

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!

Amazing!! Thank you!!

Excellent...🎉 thanks for sharing

@PowerBIPark

28 күн бұрын

Hope its useful to you :)

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

@PowerBIPark

27 күн бұрын

Awesome. Appreciate you saying so :)

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

@PowerBIPark

26 күн бұрын

Glad it was helpful!

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

@PowerBIPark

27 күн бұрын

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

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

@PowerBIPark

24 күн бұрын

Nice!

Thanks for showing things my company can actually use!

@PowerBIPark

26 күн бұрын

Glad it's helpful!

Very good implementation.

@PowerBIPark

27 күн бұрын

Many thanks

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

@PowerBIPark

28 күн бұрын

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

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

26 күн бұрын

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

hey its really awesome man. A small request from me is to create a video on dax measures😅

@PowerBIPark

20 күн бұрын

That's a big request xD can you be more specific?

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

20 күн бұрын

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

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

20 күн бұрын

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

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

@PowerBIPark

20 күн бұрын

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

Could you also please share the dataset?

@PowerBIPark

27 күн бұрын

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

26 күн бұрын

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

Is that SQL you use?

@PowerBIPark

26 күн бұрын

only DAX in this video

@ShoOnlineAcademy

26 күн бұрын

@@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

26 күн бұрын

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

@ShoOnlineAcademy

26 күн бұрын

@@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

26 күн бұрын

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.