Dynamic Pareto Analysis in Power BI - Native Visuals
HTML-код
- Опубликовано: 10 сен 2024
- 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
![[IBCS] Advanced Power BI Tutorial - Native Column Chart](/img/1.gif)
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
This is the BEST Pareto Analysis in PBI I can find! Wonderfully done! Bravo!!
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!
Awesome, thanks for the feedback! Its something different I tried out, and I'm glad it resonated
Thank you!... you are very kind showing the "magic" on this sort of nice dashboard. I really appreciate it!
Happy to see you find value in it. Hopefully it'll be useful to you :)
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😇
Thanks James :)
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.
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!
excellent demonstration as always. Your impact on Social Media is out of this world. Thank you very much
I appreciate that! If I don't see you on linkedin after a video I'll start to worry xD
@@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! 👍
Great, I hope you learned something new from this :)
Thanks for showing things my company can actually use!
Glad it's helpful!
You deserve 100k followers! What you taught today was really 👌
Awesome. Appreciate you saying so :)
Thanks for making this video!
Excellent! Following you on LinkedIn and was waiting for this video :)
Hope you enjoy it!
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
ah yes, but Pareto with negative doesn't always work - waterfall might be better :)
I cant manage to get the error bar line... I have 0 as min in Y/second Y but 2500 000 in Y and 1 in Second Y.
excellent.....love Pareto 80/20 rule, used it before
for sure! it's a shame it's not out of the box in power bi, but this will do the trick :)
Thank you so much! Amazing work
Thank you. I'm definitely going to try this.
Nice!
Legend! I am already following you on LinkedIn! thank you so much for your video!
Nice one. Hopefully this and the other videos help you out :)
Hello Sir,
Will you please upload and teach DAX related videos on your channel ?
Your style of explaining is good !
It is really helpful. Thank you and keep it up.
Glad it was helpful!
Excellent...🎉 thanks for sharing
Hope its useful to you :)
Amazing!! Thank you!!
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?
Very good implementation.
Many thanks
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)
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 :)
Could you please do the Data Analysis on Real Estate Project.
Great content! Thanks for that!
I have only one question which is if there are any smart way to perform the Pareto analysis varying the X-axis, using a field parameter for example, without having to multiply the number measures by the number of itens in the field parameter. I couldn't figure it out by myself.
It's a great question, and something I'm going to try to show in my next video. I'm going for a big one where I'm making a 1h+ course (on yt) to try to combine this and some other videos to make a full dashboard ;)
But the answer is that you basically need a switch measure on the Dax so that based on your field parameter selection, the rankx is going to use the selected column :)
@@PowerBIPark Thanks for the suggestion. This is what I actually did but it seemed to be not the smartest way to make that. I also tried calculation groups but for some reason I can't remember right now it wasn't viable in order to create the bar/line visual.
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🙏
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
A good way is to use window functions to resolve it :)
How did you get the paretovalue, the slicer you move around, precentage.
It's the numeric range parameter, paretovalue = selectedvalue(parameter)
Is that SQL you use?
only DAX in this video
@@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?
This is mock data, but you could for sure connect d365 data (I'm assuming dynamics) to power bi to do this
@@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?
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.
Could you also please share the dataset?
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:)
@@PowerBIPark Oh, totally makes sense. Thank you!