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.
I am facing this exact issue of equal(ish) revenue which is impacting the cumulative %. What workaround do I need to employ to get around this issue? I'd appreciate your input.
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
Hi Injae. I really liked your video, but I noticed you're working on a table where customers values are unique, and I am having troubles to replicate the dynamic filtering ("Others") because I have multiples records for the same customer. What do you recommend me to do to overcome this issue? I can summarize my data cause I would lose some of the granularity.
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.
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?
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 :)
Hi, i have a company data for which I am doing this analysis. Now the data is for last 2 years. When I am applying date filters, it is messing up the group 1 and 2. Is there any way to correct that?
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🙏
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 ok I fully understand. I have adapted your example but I have performance issue with the cumulative calculations (very long to calculate when I have 1000 customers for example). Is there a way to improve this point?
@@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.
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:)
This is the BEST Pareto Analysis in PBI I can find! Wonderfully done! Bravo!!
Thank you for your great work 🙏
Thanks, I appreciate it!
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 for this very detailed tutorial. So well explained!
Awesome! My second ever super thanks. Appreciate it :)
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
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
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 :)
You deserve 100k followers! What you taught today was really 👌
Awesome. Appreciate you saying so :)
Awesome video!!!!
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 :)
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!
I am facing this exact issue of equal(ish) revenue which is impacting the cumulative %. What workaround do I need to employ to get around this issue? I'd appreciate your input.
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 :)
Thanks for showing things my company can actually use!
Glad it's helpful!
Excellent! Following you on LinkedIn and was waiting for this video :)
Hope you enjoy it!
Thanks for making this video!
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 :)
Subscribed. Bravo sir. Gonna save more of your videos and incorporate into my analysis approach
Thank you so much! Amazing work
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 :)
Amazing!! Thank you!!
Excellent...🎉 thanks for sharing
Hope its useful to you :)
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. I'm definitely going to try this.
Nice!
Very good implementation.
Many thanks
It is really helpful. Thank you and keep it up.
Glad it was helpful!
Hello Sir,
Will you please upload and teach DAX related videos on your channel ?
Your style of explaining is good !
Hi Injae. I really liked your video, but I noticed you're working on a table where customers values are unique, and I am having troubles to replicate the dynamic filtering ("Others") because I have multiples records for the same customer. What do you recommend me to do to overcome this issue? I can summarize my data cause I would lose some of the granularity.
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.
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?
Can you please show the formulae for cut off customer
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.
Could you please do the Data Analysis on Real Estate Project.
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 :)
Hi, i have a company data for which I am doing this analysis. Now the data is for last 2 years. When I am applying date filters, it is messing up the group 1 and 2. Is there any way to correct that?
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 there any way to have the full pbx file? easier to understand for a non native English user.
I planned on doing it, but there's a guy who was selling my pbix for 10 usd each. I haven't since then
@@PowerBIPark ok I fully understand. I have adapted your example but I have performance issue with the cumulative calculations (very long to calculate when I have 1000 customers for example). Is there a way to improve this point?
@@keveenvigie1439 you could try using window functions instead of rankx, which might help, or use the new data limit feature, which will also help
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!